How Do I Configure the RTD Throttle Interval In Excel?
This can only be modified via the Excel object model or the registry. There is no user interface for configuring the RTD throttle interval in Excel. • If the RTD throttle interval is set to -1, this is considered manual mode, and Excel only checks for updates when Excel.Application.RTD.RefreshData is called. • If the RTD throttle interval is set to zero, Excel checks for updates every chance it gets. • If the RTD throttle interval is set to something greater than zero, Excel waits at least that number of milliseconds between checks for updates. Caution If updates come in so frequently that Excel is continuously updating values and doing calculations, Excel might end up in a state where it never gives the user a chance to do anything, effectively getting in a hung state. If this happens, set the Excel throttle interval higher. To set the throttle interval higher through the Excel object model: • In Excel, go to the Visual Basic Editor (by pressing ALT+F11 or clicking Visual Basic Editor
