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

%3CLINGO-SUB%20id%3D%22lingo-sub-1388914%22%20slang%3D%22en-US%22%3EMicrosoft%20Excel%20is%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1388914%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20I%20copy%20paste%20special%20in%20excel%2C%20my%20excel%20file%20freezes%20and%20after%20a%20waiting%20for%20a%20few%20seconds%20to%20few%20minutes%2C%20depending%20on%20the%20amount%20of%20data%20being%20copy%20pasted%2C%20I%20get%20this%20error%20'%3CSPAN%3EMicrosoft%20Excel%20is%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20action'%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20tried%20a%20few%20things%20like%20this%20but%20none%20help%20and%20the%20problem%20persists.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E1st%20troubleshooting%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1.%20Open%20the%20Excel%20sheet%20and%20go%20the%26nbsp%3B%3CSTRONG%3EFile%26nbsp%3B%3C%2FSTRONG%3Emenu.%20In%20the%20File%20menu%2C%20click%20on%26nbsp%3B%3CSTRONG%3EOptions%3C%2FSTRONG%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.%20An%20Excel%20Options%20dialog%20box%20will%20appear.%20Go%20to%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdvanced%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Etab%20and%20scroll%20down%20to%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGeneral%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3Earea.%20Over%20there%20check%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EIgnore%20other%20applications%20that%20use%20Dynamic%20Data%20Exchange%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E(DDE)%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%20class%3D%22%22%3E3.%20Restart%20Excel.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E2nd%20troubleshooting%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETried%20opening%20Excel%20in%20safe%20mode%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E3rd%20troubleshooting%3C%2FSTRONG%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERemoved%20all%20the%20Add%20ins%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E4th%20troubleshooting%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EReinstalled%20MS%20Office.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1388914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1397508%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20is%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1397508%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667495%22%20target%3D%22_blank%22%3E%40nileshparekh%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20if%20it%20helps%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fno-links-vba-addons-but-microsoft-excel-waiting-for-another%2Fm-p%2F331063%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fno-links-vba-addons-but-microsoft-excel-waiting-for-another%2Fm-p%2F331063%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

1 Reply