What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?

excel user-defined-functions rtd excel-udf vba
Frank picture Frank · Aug 25, 2011 · Viewed 12.6k times · Source

I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a sheet that includes this formula I get the following error:

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

I have checked and unchecked "Ignore other applications that use Dynamic Data Exchange (DDE)" per some forum discussion (which I can no longer locate). Neither works.

Google yields many hits for this error but no resolutions. There is an ancient knowledge base article here but again no resolution.

What is causing this error? Is there anything that I can do to avoid it?

Thanks!

Answer

PJ in FL picture PJ in FL · Nov 28, 2012

Try using Application.DisplayAlerts = False to stop the alerts from displaying.

Related questions

Refresh Excel VBA Function Results

How can I get a user-defined function to re-evaluate itself based on changed data in the spreadsheet? I tried F9 and Shift+F9. The only thing that seems to work is editing the cell with the function call and then …

Read More
Create a custom worksheet function in Excel VBA

I have a faint memory of being able to use VBA functions to calculate values in Excel, like this (as the cell formula): =MyCustomFunction(A3) Can this be done? EDIT: This is my VBA function signature: Public Function MyCustomFunction(str …

Read More
Function Overloading and UDF in Excel VBA

I'm using Excel VBA to a write a UDF. I would like to overload my own UDF with a couple of different versions so that different arguments will call different functions. As VBA doesn't seem to support this, could anyone …

Read More