Forum Discussion
Microsoft Excel is waiting for another application to complete an OLE action
Hi there,
Whenever I copy paste special in excel, my excel file freezes and after a waiting for a few seconds to few minutes, depending on the amount of data being copy pasted, I get this error 'Microsoft Excel is waiting for another application to complete an OLE action'
I tried a few things like this but none help and the problem persists.
1st troubleshooting
1. Open the Excel sheet and go the File menu. In the File menu, click on Options.
2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE).
3. Restart Excel.
2nd troubleshooting
Tried opening Excel in safe mode
3rd troubleshooting
Removed all the Add ins
4th troubleshooting
Reinstalled MS Office.
Can someone help.
41 Replies
- teribryantCopper Contributor
I have the same persistent problem, it's very annoying when I try and open excel spreadsheets and have to consistently wait for the OLE action and I've tried all the options you've listed as well.
- Blind_ImaginationCopper Contributor
If you are using Google Drive File Stream you need to turn off "real time presence" in the Google Drive settings.
I found this info here
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2019/excel-ole-error-after-move-to-google-drive/03f44a0b-ff1d-4e53-8e32-86d123bb8957
- sofiammrCopper ContributorIt was that!!! Thanks!!
- Simon_JNJ_IECopper Contributorthat works, thanks so much for sharing
- AshaKantaSharmaIron Contributor
- Vimal670Copper ContributorI tried the steps from link .still issue persist .Can someone help pls
- PWarriorCopper Contributor
My solution was disabling the McAfee real time protection. I turned off the Real Time protection in McAfee Live Safe before opening the excel file and the issue was resolved. AshaKantaSharma