Tuning RTD

The RTD mechanism is a pull-push protocol. You can control the frequency of the pull (i.e. the frequency with which Excel looks for changes in an RTD server), by using the property Application.RTD.ThrottleInterval through VBA.

1. From Excel, type Alt+F11 to show the VBA editor.
2. Type Ctrl+G to show the immediate window.
3. To show the current throttle interval in milliseconds, type:

   ?Application.RTD.ThrottleInterval

4. To change the throttle interval to 1/10 of a second, type:

   Application.RTD.ThrottleInterval = 100

Next: Further enhancements >>