Excel RTD Throttle Interval

The Excel update rate is called the data throttle interval. This defaults to 5 seconds and can only be modified via the Excel object model or the registry.

To set the throttle interval through the Excel object model:

1. In Excel, go to the Visual Basic Editor (by pressing ALT+F11 or clicking Visual Basic Editor from the Macro menu (Tools menu)).
2. In the Immediate window (press CTRL+G or click Immediate Window on the View menu), type this code: Application.RTD.ThrottleInterval = 1000
3. Make sure your cursor is on the line that you just typed, and then press ENTER.
4. To verify that it is set correctly, type this line of if code in the Immediate window:

? Application.RTD.ThrottleInterval

1. If you put your cursor at the end of this line and press ENTER, it should display 1000. Then you know that your throttle interval is set correctly.

To set the throttle interval higher through the registry:

Set the following DWORD registry key in milliseconds:

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\RTDThrottleInterva1.0.0.0 l

http://www.measuresoft.com/support/faq/post/Excel-RTD-Throttle-Interval.aspx