Can Excel throttle cell updates?
I’m developing a plugin to relay updates from a pub/sub cache into an Excel workbook hosted within office365. Update frequency can be very high (upto thousands of updates a second). Is there a guard within Excel to protect itself from bursty data, in the same vein as Application.RTD.ThrottleInterval
?
Office 365 Excel Add-in doesn’t work properly compared to Excel for Desktop
I’ve created an Excel Add-In that I have submitted to the MS Partner Center. Up to now I was really focused on Excel desktop application, but the Microsoft certification team seems to be mainly focused on Microsoft 365 web based applications. My add in works perfectly for the desktop, but not so well for the web based Excel.
Desktop:
As you enter the formula, you receive guidance: (see picture 1)
enter image description here