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

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

15-06-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

07-08-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?

Answers (15)

Answers (15)

Avatar

Avatar
Boost 1
Level 1
jamesc82861453
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
jamesc82861453
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
jamesc82861453
Level 1

09-08-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.

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

07-08-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.

Avatar

Avatar
Boost 1
Level 1
jamesc82861453
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
jamesc82861453
Level 1

Like

1 like

Total Posts

11 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
jamesc82861453
Level 1

03-08-2018

Guys,

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

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

17-07-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.

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

27-06-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...

Capture.PNG

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

19-06-2018

Gotcha. Thanks for this suggestion I'll give it a shot and report back on it.

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

19-06-2018

By granularity I meant was it broken down by month, week or day was all. In your case its granularity of day I would guess.

If its ram then I also would look at the System pagefile. I bet its really low in teh 5 to 50 meg range. (In system setting find memory and look for virtual memory) As long as you have decent harddisk space bump it up to 5 or 10 gigs. That should help right away. Still ram is best but this should solve immediate needs.

GLTU

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

19-06-2018

I've already requested additional RAM in order solve this issue and we'll see once I have that installed whether it helps.

I'm try to run top 10, 7 days back and I'm not sure what you mean be granularity.

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

19-06-2018

I have run many large report builder exel files and they work well. Granted I had issues prior but it was related to poorer capacity of PC running things.

Excel recovery works for elements built natively in excel, the "Add In" is a separate technology plugin so reliance on one vendor supporting anothers crash behavior will always be touch and go.

I agree it can be frustrating but bear in mind you can adjust the reporting rows as you desire. If you are trying to process 10s of thousands of rows for one line item (also then have multiple line items ) then I think you should revisit the tool you are using here. I don't know the file stats in your case, but perhaps data warehouse is more appropriate for you if that is indeed the case.

How many items by how many rows are you trying to run? What is time frame and granularity?

Avatar

Avatar
Validate 1
Level 1
Mia_C
Level 1

Likes

0 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Mia_C
Level 1

Likes

0 likes

Total Posts

14 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
Mia_C
Level 1

19-06-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.

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

19-06-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

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

18-06-2018

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

Avatar

Avatar
Contributor
Level 3
suneeshkachroo
Level 3

Likes

16 likes

Total Posts

50 posts

Correct reply

17 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Contributor
Level 3
suneeshkachroo
Level 3

Likes

16 likes

Total Posts

50 posts

Correct reply

17 solutions
Top badges earned
Contributor
Shape 1
Give Back 5
Give Back 3
Give Back
View profile
suneeshkachroo
Level 3

18-06-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

1510929_pastedImage_2.png

Avatar

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
blakelt88
Level 1

Likes

0 likes

Total Posts

8 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
blakelt88
Level 1

18-06-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?

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

870 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

315 likes

Total Posts

870 posts

Correct reply

264 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

18-06-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