Report Builder - Microsoft Excel is waiting for another application to complete an OLE action | Community
Skip to main content
B
bturle
New Participant
June 15, 2018
Solved

Report Builder - Microsoft Excel is waiting for another application to complete an OLE action

  • June 15, 2018
  • 16 replies
  • 7960 views

Hello,

I'm trying to pull data with Report Builder. I'm able to login successfully and state which Report Suite I'd like to use and also what data from it I'd like, but once I tell it to execute the data pull it hangs and eventually the message, "Microsoft Excel is waiting for another application to complete an OLE action" appears and if I hit OK it just repeats this over and over after hitting OK. I have to force quit Excel to get it to stop. I need this to work and it's critical I get it working ASAP.

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Pablo_Childe

I would also ensure you dont have multiple excel files open at once. Remove unnecessary blank tabs, or unused data blocks.

Also have you tried to see if saving into a newer excel version of excel helps(in case file is corrupted)?

Failing that try and open it on a completely different PC to see if you can remove PC itself as a problem component.

Are you admin on this PC? Could it be a quirky admin permission issue?

16 replies

Show previous replies
M
Mia_C
New Participant
June 19, 2018

This is one of the most frustrating bugs of Report Builder because when you kill Excel it doesn't come back as a recovered workbook.  It's such a huge time waster.  The fact that so many people have this problem should indicate to Adobe that it needs to be corrected rather than having the end-user update in smaller updates or in smaller files.  Report Builder has set limits to the number of rows it will return at one time and the number of requests that can be built in a single workbook. If Report Builder isn't capable of managing that many they should reconsider the limits.

Pablo_Childe
Pablo_Childe
New Participant
June 19, 2018

I have seen where if select many many rows at once and try to update them simutaniously it hangs excel. Try doing one line item at a time. Slower but at least will fix random hangs. ( likely caused by large file and poor PC memory availability). Quit any unnecessary apps as well outside of excel.

GLTU

B
bturleAuthor
New Participant
June 18, 2018

Thanks for the reply. I have tried this method and haven't been able to get it to work unfortunately with it.

suneeshkachroo
suneeshkachroo
New Participant
June 18, 2018

Have got the same issue OLE error, In one case we are able to fix this with disabling DDE from Excel Options  and restart the machine

B
bturleAuthor
New Participant
June 18, 2018

Hi Pratheep,

I'm not sure I understand what you are saying. How do I reduce the size of Excel to a minimum and how to do run Report Builder on a Small Size Excel?

PratheepArunRaj
PratheepArunRaj
New Participant
June 18, 2018

Dear Blakett,

Reduce the size of the Excel to the minimum. Do not run Report Builder on the Huge Size Excel.

Update your Report Builder for latest version and try to run. It should work.

Thank You

Arun

Terms & ConditionsAccessibility statement

Loading footer...