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 !

2 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)