Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Data Refresh - OLE Action Error Message
Hi,
When trying to refresh data on the excel sheet i get a message saying "Microsoft Excel is waiting for another application to complete an OLE action", this appears after a few minutes of loading and then keeps appearing every 10 seconds when i click "OK", are you able to suggest a method of getting around this issue?
Thanks!
When trying to refresh data on the excel sheet i get a message saying "Microsoft Excel is waiting for another application to complete an OLE action", this appears after a few minutes of loading and then keeps appearing every 10 seconds when i click "OK", are you able to suggest a method of getting around this issue?
Thanks!
Comments
1. What version of Excel are you using?
2. Have you installed PowerPivot for Excel 2010 or Enabled PowerPivot in Excel 2013/2016 (depending on the version you are using)?
3.
1. I am using Excel 2013.
2. It appears that i do not have PowerPivot on my Excel 2013 (its not even present in File>Options>Add-Ins>Manage COM Add-ins) - i will look to install PowerPivot, or get a new Excel version
Thanks