15 second throttle when Excel doesn't have focus

[Mark Simmons]

Is there any way of getting around this?

This is using a C# addin in Excel365. In debug mode I can see OnNext being called much faster and if Excel has the focus the cells update just fine. When I click on another app though, the cells only update every 15 seconds.

Any help appreciated.

Cheers,

Mark.

[Govert van Drimmelen]

Hi Mark,

This might relate to how your add-in implements the Rx publisher, rather than Excel or Excel-DNA throttling the RTD.
The Rx OnNext call is made by your add-in code, not by Excel - so if your add-in stops calling OnNext when Excel does not have the focus (perhaps due to Windows message processing that drives your Rx publisher) then you'll see this behaviour.
Excel's RTD mechanism has a 'heartbeat" check when there are no RTD calls, and this defaults to 15 seconds, so maybe that is somehow driving your slower updates.

If you want to dig a bit further, I'd be happy to help.

-Govert

[Mark Simmons]

OnNext is still being called. The issue manifests its self when the spreadsheet takes too doing its calculations on the new data. If it takes longer than the RTD throttle when Excel doesn't have the focus, Excel will kick in its 15 second throttle. As the results of the calculations are then passed on we need Excel to carry on updating the cells whether it's in focus ot not.
I just wondered if you've encountered this yourself and if you have any suggestions for getting around it.

Many thanks, Mark.