Report Builder - Microsoft Excel is waiting for another application to complete an OLE action | Community
Skip to main content
B
bturle
Level 2
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
B
bturleAuthor
Level 2
June 27, 2018

Alright so I now have 20 gigs of RAM on this laptop and I'm still getting this error so I think it's safe to say that this isn't a memory issue...

Gigazelle
Adobe Employee
GigazelleAdobe Employee
Adobe Employee
July 17, 2018

Couple questions for you:

  • Does it hang when starting with a fresh workbook? As in load a brand new excel file, log in to Report Builder, and pull a pages report for yesterday's data?
  • Do you have 64-bit or 32-bit Excel installed? If you have 32-bit Excel installed, do you have access to upgrade to 64-bit? 32-bit Excel has a cap to how much RAM it can use (I think ~3GB), which might be the bottleneck to your available 20GB of RAM.
jamesc82861453
jamesc82861453
Level 2
August 3, 2018

Guys,

I am also getting the same error. Was there any workaround. Please share if there is any workaround. Thank You

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity AdvisorAccepted solution
Community Advisor
August 7, 2018

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?

B
bturleAuthor
Level 2
August 7, 2018

For me, this was the correct answer. It looks like this is a firewall issue as this is my work computer. I was able join a different network and successfully make the request.

jamesc82861453
jamesc82861453
Level 2
August 9, 2018

Hey pabloc82923542,

I was able to get it done on my personal laptop rather than company laptop. So your 3rd point worked for me. Thanks.

Terms & ConditionsAccessibility statement

Loading footer...