Excel waiting for another application to complete an OLE action - no addons/links/network drives

%3CLINGO-SUB%20id%3D%22lingo-sub-2055133%22%20slang%3D%22en-US%22%3EExcel%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20action%20-%20no%20addons%2Flinks%2Fnetwork%20drives%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2055133%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EBeen%20stuck%20with%20this%20one%20for%20a%20while%20now%20-%20I'm%20trying%20to%20run%20a%20vba%20macro%20which%20hooks%20into%20a%20running%20instance%20of%20another%20program%20and%20extracts%20some%20data%20out%20of%20it.%20Unfortunately%20it%20keeps%20throwing%20the%20OLE%20action%20waiting%20message%20(the%20data%20still%20comes%20through%20but%20it's%20an%20absolute%20pain%20to%20keep%20clicking%20on%20the%20OK%20button).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20I've%20tried%20the%20following%3A%3C%2FP%3E%3CP%3E-%20Checked%20in%20safe%20mode%3C%2FP%3E%3CP%3E-%20Reinstalled%20office%3C%2FP%3E%3CP%3E-%20Checked%20on%20DDE%20(tested%20by%20checking%20it%20off%20as%20well)%3C%2FP%3E%3CP%3E-%20looked%20through%20this%20other%20thread%20(%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)%3C%2FP%3E%3CP%3E-%20Checked%20for%20hidden%20links%20using%20the%20Inquire%20plugin%20(there%20aren't%20any).%3C%2FP%3E%3CP%3E-%20Closed%20internet%20explorer%20instances%20manually%20via%20task%20manager%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENone%20of%20these%20have%20helped.%3C%2FP%3E%3CP%3ENote%20that%20I'm%20running%20the%20excel%20file%20off%20of%20a%20local%20copy%20(no%20shared%20network%20shenanigans%20here%20!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20pretty%20much%20at%20the%20end%20of%20my%20rope%20!%20Any%20advice%20would%20be%20greatly%20appreciated%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2055133%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2189798%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20action%20-%20no%20addons%2Flinks%2Fnetwork%20drives%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2189798%22%20slang%3D%22en-US%22%3EAre%20you%20using%20Google%20Drive%20and%20have%20the%20desktop%20app%20installed%3F%20If%20so%2C%20try%20logging%20out%20of%20the%20app%20(File%20Stream%20or%20whatever%20is%20the%20latest%20name).%20This%20workaround%20did%20it%20for%20me.%20Not%20a%20solution%20of%20course.%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

Been stuck with this one for a while now - I'm trying to run a vba macro which hooks into a running instance of another program and extracts some data out of it. Unfortunately it keeps throwing the OLE action waiting message (the data still comes through but it's an absolute pain to keep clicking on the OK button).

 

So far I've tried the following:

- Checked in safe mode

- Reinstalled office

- Checked on DDE (tested by checking it off as well)

- looked through this other thread (https://techcommunity.microsoft.com/t5/excel/no-links-vba-addons-but-microsoft-excel-waiting-for-ano...)

- Checked for hidden links using the Inquire plugin (there aren't any).

- Closed internet explorer instances manually via task manager

 

None of these have helped.

Note that I'm running the excel file off of a local copy (no shared network shenanigans here !)

 

I'm pretty much at the end of my rope ! Any advice would be greatly appreciated !

4 Replies
Are you using Google Drive and have the desktop app installed? If so, try logging out of the app (File Stream or whatever is the latest name). This workaround did it for me. Not a solution of course.

@Vidish 

How to fix the Excel is waiting for OLE problem

 

The first solution, of course, is to restart your machine and try again. If the problem persists, try the following workarounds:

 

  1. Activate the option Ignore other applications using the DDE function

    Open the Excel table

    Go to the File menu

    Click on Options

    Go to the Advanced tab

    Scroll to the General section and enable Ignore other applications that use Dynamic Data Exchange (DDE)

 Restart Excel

 

  1. Deactivate add-ins

    Open the Excel table

    Go to the File menu

    Click on Options

    Click on Add-Ins

    Select Excel Add-Ins and click the Go button

    Uncheck all fields and click OK

 

  1. Other methods of attaching the Excel workbook

Using the Excel Send Email option can result in the above error. You can send your workbook by attaching it as a file to an email in Outlook or Hotmail, for example. You can use any email application to solve the problem.

 

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)

This solution can fix the problem temporarily but not for a long run.

@MuhammadMohsin 

The only thing I can give you with my little knowledge on the way is ..

Use other ways to attach an Excel workbook

The error occurs when attempting to use Excel's “Send by E-mail” option.

So here it is recommended to try other ways to attach the Excel workbook.

Try sending your Excel workbook by attaching it to an email as a file in Outlook or Hotmail or any other email app to resolve the issue.

Well, it is estimated that after following the above given solution, Excel waiting for OLE action error will be fixed. If not, use MS Excel automatic repair tool.*

 

*

The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)