Forum Discussion

bjornliow's avatar
bjornliow
New Contributor III
2 days ago

Microsoft excel is waiting for another application to complete an OLE action

Hi,

We are transitioning over to OneStream version 9.0.1. As part of the transition, we are running validations on the data we have copied over from our previous environments.

We are running reports like quickviews & XFGETCELLs to retrieve data. However, after clicking on Refresh Sheet/Workbook, we are prompted with the error message:

Microsoft excel is waiting for another application to complete an OLE action

Does anyone have a solution to this resolve this issue? This is holding us back with our validations, ultimately affecting our go-live date if this issue persists. We would not feel confident going live if this Microsoft Excel error continues to impact our user base from running their reports. 

For additional context:

  • Microsoft Excel is 64-bit version
  • Excel Add-in version 9.0.1 is installed. 
  • Tested on multiple reports along with recreating reports
  • Tested with multiple users/devices
Excel Add In

1 Reply

  • 1392's avatar
    1392
    New Contributor III
    24 hours ago

    There are various posts about this same excel pop-up message and it happens because of various reasons i.e., excel being on 32 bit vs 64 bit. We are on 64-bit excel and faced this issue during the upgrade process but still proceed to go-live with 9.0.1. Do note that this message does not stop the sheet from refreshing the data but you need to click ok each time it pops-up as the sheet still continues to refresh the data in the backend. So if the sheet takes 10min to refresh, you can keep clicking ok on the OLE message each time it appears or wait for 10 min and once you see your session complete in task activity click ok at the end to see the numbers. 

    Do report this issue to your CSM if you are on 64-bit and the work arounds posted around this topic does not help you in any way.