Hello,
Since this morning, when I use a connector, Excel freezes for 1 minute or more, then throws and error: "Microsoft Excel is waiting for another application to complete an OLE action."
It then returns the relevant value without any further problem.
Tested on an empty document as well as on a work one
Tested with the Ahref, Majestic or SEMRush connectors
This happens the first time I am using a connector during an Excel session. Subsequent queries work with no delay.
I have tried to check the "ignore other apps using dynamic data exchange" in the advanced options as recommended on the MS website, to no avail.
This only happens when the following option is set to true.
<RunAsyncUdfsSynchronously>false</RunAsyncUdfsSynchronously>
BTW: I have automatic formula calculation disabled.
Any thoughts on this?