Welcome Guest, you are in: Login
CTS Futures
Home
Pricing
Market Data
FAQ
Videos

T4 Desktop
User Guide
Scripting Guide
Release Notes

Mobile and Web
T4 Mobile for Android
T4 Mobile for iOS
T4 Mobile for Browser
T4 WebTrader

Admins
T4 Admin Guide
MiFID II/MiFIR

Developers
API 4.7 Guide
FIX API
API 4.0 Guide
API 4.0 Reference


Original text


Original text


Breaking Microsoft Excel DDE Links

RSS
Excel will allow a user to manually edit excel links. This provides the opportunity for end user error in the form of a typo as Excel DDE links are case sensitive. If a typo occurs the user will have no choice but to remove the broken link and create it correctly from scratch. This is a limitation in Excel.

An example would be if the month is changed using lower case charactors. Excel won't allow the correction of the formula and the formula will never again work.

In Excel 2010 go to the Data tab and click Edit Links.

A dialog will be displayed.

Find the broken link and click "Break Link" and close the dialog.

Use T4 to generage the correct link so that there is no chance of a typo.

Image
  Name Size
- BreakLink.png 71.22 KB

Trade how you want, where you want

support@ctsfutures.com (312) 939 0164

111 W. Jackson Blvd., Suite 1408, Chicago, IL 60604

© 2009-2017 Cunningham Trading Systems LLC All rights reserved.