To run RTD on our platform you need to upgrade and add the RTD add-in. First step is to enable the add-in on the platform

open excel > File > options

add-ins > scroll to find T4Excel Add-in

click Go next to manage add-ins

check off t4excel add in and hit ok

that will allow people to use =t4. formulas

old formulas like this

do a find/replace “=rtd(” to “=rtd.t4(”

here is the T4 Excel Example workbook too

that work book has a macro in it that just sets the rtd update interval to 100ms when it opens Application.RTD.ThrottleInterval = 100

The RTD throttle interval determines how often updates are made to Excel. When Excel Tools is installed, the RTD throttle is automatically set to 2000 milliseconds (2 seconds) between calls for new data. Typically, you will never have to change this setting.

Change the RTD Throttle Interval

To set the throttle interval lower through the Excel object model (change from 2000 milliseconds to 500 milliseconds, or 0 seconds to update as fast as possible):

1. Open Excel

2. Open the Visual Basic Editor by pressing ALT+F11, or by clicking Visual Basic Editor from the Macro menu (Tools menu).

3. In the Immediate window (press CTRL+G or click Immediate Window on the View menu), type this code: Application.RTD.ThrottleInterval = 0

4. Make sure your cursor is on the line that you just typed, and then press ENTER.