Error message: "Microsoft Office Excel is waiting for another application to complete an OLE action"

Article translations Article translations
Article ID: 2698564 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you open or use a Microsoft Excel 2010 workbook, a Microsoft Office Excel 2007 workbook, or a Microsoft Office Excel 2003 workbook, you receive the following error message:
Microsoft Excel is waiting for another application to complete an OLE action.
You may receive this error message if any of the following actions occur:
  • You try to use the Send as Attachment option in Excel.
  • You try to open an embedded object in Excel.
  • The Excel worksheet tries to access data from another application that is still active.
  • Too many Excel add-ins have been added to the program, or one of the add-ins is corrupted.

Resolution

To resolve this problem, use one or more of the following methods.

Method 1: Use a different method to attach the Excel workbook to an email message

Method 2: Close the application that interacts with Excel

Method 3: Troubleshoot add-ins in Excel

More information

The information provided in this section is for advanced users.

If you created a workbook that is automating another application through VBA, you can add the following line of code to turn off the message:

Application.DisplayAlerts = False

Collapse this imageExpand this image
2683283
Note In the code that performs the automation, this line of code must precede the call for the line of code that causes the error.

Properties

Article ID: 2698564 - Last Review: May 28, 2014 - Revision: 4.2
Applies to
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
Keywords: 
kbsurveynew KB2698564

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com