We have a recent update to Office 365 and I'm being prevented from running the MxRunAction macro.
The workbook opens with no errors, and I can use the Test Connection button successfully. When I attempt to run a simple query on the ASSET object, the progress form opens but as soon as the status message changes to Populating Sheet, Excel throws the following:
After clicking OK, Excel shuts down and reopens the same workbook with a red banner at the top.
I and my IT support have gone through a ton of combinations in the Trust Center with trusted locations, etc. and haven't been able to fix it. What's got us confused is that the macro isn't actually blocked; apparently something within the macro is tripping a flag. Anyone else having issues?
------------------------------
Robert Goff
Xanterra Travel Collection
------------------------------