Forum Discussion
no links/VBA/addons, but : Microsoft excel waiting for another application to complete an ole action
Hi,
Excel stops working about every 20 minutes for a few minutes -I just have to wait - and then this message pops up: ""microsoft excel waiting for another application to complete an ole action". Thereafter it works again, I can save etc., but it is highly interruptive and annoying.
The excel files does not have any links, embedded files, not a single add-on is activated in excel.
I have checked all the common hints that can be found, ticked "ignore other applications using DDE" in excel options, updated the office package, updated windows - nothing I have tried so far helps.
Again, the weird thing is that there are no embedded links or the like, and I have no idea what the reason could be for this error message to keep emerging.
Any advice is highly appreciated!
Thanks
Helen
50 Replies
Please deactivate the add-ins in Excel and Word (via File> Options> Add-Ins> COM-Add-Ins> Go to / Go) and test the behavior.
If this does not help, set the check mark for hardware graphics acceleration in Word via File> Options> Advanced> Display and test the behavior.
If this doesn't help either, proceed as follows:
Login as administrator required
- Press the key combination Windows key + R on your keyboard. The Run dialog box opens.
- Enter the command appwiz.cpl and click OK.
- Find your Microsoft Office 365 in the list.
- Click on it with the right mouse button and select Change.
- Select Online Repair and click Repair.
- Wait until the repair is complete and restart your computer.
- Test the behavior of Office.
I wish you a lot of fun with Ecel.
If this information helped you, please mark this post as "Correct answer" and click on like (hand with thumbs up), so that other members can benefit from this information later.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- Thanks. That's worked for me. The issue was almost ruined my day. I just went to online repair Microsoft excel 365 and uninstalled all previously installed office version and cleared DDE. Now it's works fine. The file were shared in Google drive. Thanks a lot.
- Hi Harikumar_Ganesan
Glad that worked for you. What version of Excel and Windows were you using at the time?
- Thank you very much, this solution helped me and saved my life.
I am new to the community and my mother language is not English, sorry if my spelling is not correct.
I don't know how to indicate that your answer was correct or very helpful, but I would.
Thank you very much once again, greetings from Peru.Hi, I am happy it worked for you and pleased I could help.
Your English is very good and much better than my Peruvian.
This did it for me! Thank you SOOOO much!!!!!
Update for context: ankkit's reply regarding files located on Google File Stream / Google Drive was my issue resulting in the "waiting for OLE action" error. I tried disabling add-ins, but that wasn't the issue in my case. I probably shouldn't pass the buck on this one, but it should be brought to the attention of the respective MS and Google Product development teams.
Error: "Microsoft excel waiting for another application to complete an OLE action."
Cause: Certain Excel files being stored on Google Drive or Google File Stream.
Solution: Moving the files to a local drive or desktop (i.e. the hard drive).
EdGrahamV We have been facing this issue since a long time. I have tried all the options like. Removing the add ins. Even I suspected that it may be due to Google Drive Files stream. But we are getting this error even for other excel files which are on Desktop.
Any one with solution please help.
Thanks
While the error message is always the same, there are actually a couple of pretty common scenarios that trigger this particular error in Microsoft Excel:
DDE protocol is deactivated in Excel - This problem can occur because the DDE protocol (Dynamic Data Exchange) is deactivated in the Excel settings.Corrupt Office Installation - Some users have reported that the problem was resolved after reinstalling or repairing the entire Office installation.
Adobe Acrobat PDFMaker add-in conflicts with Excel - There have been some reports from users who were able to fix the problem by disabling or uninstalling the PDFMaker plug-in.
IE (Internet Explorer) process is interfering with the DDE - this usually occurs when the user tries to save a file in Microsoft Excel. In this case, the solution is to manually end the process.
Examble for DDE protocol, a quick guide.
Open Microsoft Excel and click on File.
It doesn't matter whether you're opening a new workbook or a new document.
Open Microsoft Excel and go to File
On the File menu in the left pane, click Options.
Go to File> Options
From the Excel Options menu in the left menu, click the Advanced tab.
Then move to the right pane and scroll down until you get to the General section.
Make sure that the Ignore other applications using Dynamic Data Exchange (DDE) check box is cleared.Examble for Adobe Acrobat : In the COM Add-Ins box, either clear the check box for the Acrobat PDFMaker Office COM Add-in, or select it and click Remove to delete it completely.Examble for IE explorer: Press Ctrl + Shift + Esc to open Task Manager.
Switch to the Processes tab in Task Manager and check whether an Internet Explorer process is currently active.
If one is open, just right click on it and choose End Task to close it.
End the Internet Explorer (IE) process
Return to Excel and see if the "Microsoft is waiting for another application to complete an OLE action" error still occurs when you try to save the file.Wenn das alles nicht geholfen hat , dann hilft nur (maybe) die Unterdrückung von Excel Application Messaging mit VBA or turn off compatibility mode .I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
I had a user with this exact same issue, I ran the online repair cycle for Microsoft Office (we have O365) and rebooted, this fixed the issue.
Keep in mind that I removed Adobe Acrobat add-in but that didn't work, and I didn't adjust it again after the repair cycle was finished.NikolinoDE
- This happens to me once a while after I close Excel. The notice either would not allow me to close the application or prevent me from opening it.
My workaround has always been to open up Task Manager and end all Excel sessions only. I found this to work all the time although a few times active files are closed and I lose some data. Nothing brutal so far.Same problem for me.
Posting here since I don't know where to look for a solution anymore.
Hope Microsoft will take care of this very soon.
HI,
Is your excel file stored in a shared drive? or is locally on your computer?
in case it is on a shared drive please try to move it to your computer to see if you have the same problem, in case the problem will not occur , you can try to upload it on SharePoint to be "shared" with others.
Regards,
Costin
- Hi Helen,
I suspect there is a hidden link that you're not able to see via normal "Built in" Excel tools like DATA --> EDIT LINKS.
Sometimes these are buried in things like charts, that have been copied from one file to another.
Download an Excel add-in tool from Microsoft called "INQUIRE". That add-in allows you to interrogate the whole spreadsheet and reports ALL links. Then you should be able to remove them.
NNauthstar Thank you for the suggestion. I'm having similar problems with waiting for OLE, but I do not see an "INQUIRE" add-on in the list when I access them from the Insert menu in Excel.
- Hi Jonathan_T330 , You have to search and download it from the Microsoft website. Save it where your other add-ins are located, open excel and add it as normal.
Kind regards
Thanks for suggestion however I want to keep links and I think there should be an option to terminate an OLE instance if a referenced application is closed for any reason and excel still needs it. I use Thomson Reuters add-in as an example and if I close TR for any reason and my spreadsheet has not finished use of the add-in it will just keep popping up the OLE waiting message ... basically hanging forever without possible remedy except ctrl/alt/del and terminate excel with possible consequence of losing work I have not saved. Re-starting the application add-in by the way does not fix the issue until excel is terminated and re-started. Very frustrating.
I have a non Thomson Reuters add-in that I guess hangs in the same way you mention. Very frustrating as it only does it occasionally. In my case I have to remember to either complete what I'm doing with the section I've added in and then switch to the add-in's main menu - this ensures it's in a steady state before I analyse my results or alternatively, I have to go to Excel's Data menu and disable the add-in temporarily whilst I do other analysis. Afterwards, I re enable the add-in and close the workbook.
I don't know any other way around this.
I guess the OLE does some kind of polling to ensure connection otherwise you could end up with broken links or worse calculations that are changed to values.
