desktop:desktop_rtd_update [WIKI]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Updating to new RTD ======
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 

{{:desktop:enable_rtd_11.png|}}

open excel > File > options

{{:desktop:rtd_step_1.png|}}

add-ins > scroll to find T4Excel Add-in

{{:desktop:rtd_step_2.png|}}

click Go next to manage add-ins

{{:desktop:rtd_step_3.png|}}

check off t4excel add in and hit ok

{{:desktop:rtd_step_4.png|}}

that will allow people to use =t4. formulas

{{:desktop:rtd_step_5.png|}}

old formulas like this

{{:desktop:rtd_step_6.png|}}

do a find/replace "=rtd(" to "=rtd.t4("




{{ :desktop:updatedrtdsheet.xlsx |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

====== RTD Throttle Interval ======
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.