By default, Microsoft Excel will throttle RTD updates into your spreadsheet. This means that data can be delayed, especially if you are expecting multiple updates per second.
To check your current RTD throttle interval, follow these steps:
- Open the Visual Basic editor using Alt + F11
- Open the Immediate Window using View->Immediate Window or Ctrl + G
- Type into the immediate window, “?Application.RTD.ThrottleInterval” (without the quotes) and press Enter
The default value for Excel is 2000 milliseconds or 2 seconds, which means that updates will not be refreshed within 2 seconds of each-other in your sheet.
How to change the RTD interval
You can set a new value for the RTD throttle interval in the same immediate window as above, using the following syntax:
which would set the throttle to 1 second.
To remove the throttle completely, and have Excel send updates as quickly as it can to your spreadsheet, you can turn it off with