How to resolve Excel error “MS Office Excel is waiting for another application to complete an OLE action"

-

It is not uncommon to receive error messages in Excel. Sometime these error messages are so strange and weird that it becomes very difficult to understand them. Today I will talk about one such error in Excel.

“MS Office Excel is waiting for another application to complete an OLE action.”

The above error may occur when you try to open your Excel sheet. There are three main reasons for the occurrence of this error:
  • This error may occur when you use 'Send as Attachment' option of Excel to send the Excel sheet as an email attachment.
  • If Excel is trying to access data from an active application.
  • You have added too many add-ins in your application.


Methods to resolve the error:

Use a different email program to send your Excel sheet as an attachment: You can try to send your Excel sheet using 'Send Using Email' option in Excel. If you still encounter above error then you can send your Excel sheet by following methods:
  1. Attach your file using MS Outlook.
  2. Send your Excel sheet using Hotmail.
Close all the programs that are interacting with your Excel: This error may encounter if Excel is interacting or accessing data with other application and that application is inactive. In this case it is recommended to close Excel and other application and again reopen your Excel. If error is still occurring then you need to enable the 'Ignore other applications that use DDE' feature. Follow below steps to do this:
For Excel 2010:
  1. Open your Excel sheet.
  2. Go to File-> Options.
  3. Go to Advanced tab and click 'Ignore other applications that use Dynamic Data Exchange (DDE)' in the General area.
For Excel 2007:
  1. Go to MS Office button-> Excel Options.
  2. Go to Advanced tab and click 'Ignore other applications that use Dynamic Data Exchange (DDE)' in the General area.
Disable the add-ins temporarily: The above error may also occur if your system has too many add-ins and one of the add-ins is corrupt. So disable all add-ins temporarily and see if error occurs. Follow below steps to disable add-ins:
  1. Open your Excel file.
  2. Go to File-> Options-> Add-ins.
  3. Now click Manage Box-> Excel Add-ins-> Go.
  4. Clear the checkbox next to each add-ins in the Add-ins available box.
If after performing above steps error does not occur then add the add-ins one by one until the problem occurs again.

Comments

  1. Unknown27 November 2016 at 17:06

    I am always using MS Office and that is why that software is very important to me.

    ReplyDelete
  2. Anonymous16 December 2016 at 23:04

    Need technical help for MS office setup 2013 ? call 1-855-441-4419 MS office helpline number for technical support or account verification for MS office setup 2013.

    ReplyDelete
  3. اسماعیل کرباسی19 December 2016 at 23:02

    great....

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Fix Issues with Excel File Save

-
Sometimes users face problem in saving Microsoft Excel files. Excel shows different type of error messages while saving the file such as “Errors were detected while saving C:/Users/Filename.xlsx”, “an error message indicating the document was not saved or that someone else is using the file and can’t be saved”. You may face these types of issue while saving Microsoft Excel files if one or more of the following conditions are true. You have limited permissions to a network drive and you are trying to save an Excel file there. You do not have sufficient drive space and trying to save an Excel file to that location. While saving the Excel file, you have lost the connection to the file. Antivirus software program arise conflicts with the Excel file save. You are trying to save a shared Excel file. The path length for the Excel file exceeded than 218-characters. Excel file is damaged or some data in the file is corrupt. Here are some methods to troubleshoot Excel saving prob
Read more

How to disable “Enable Editing” option in MS Word 2010?

-
Image
Have you ever worked on Word 2010? If yes then you might have noticed that whenever you open any document in Word 2010 and try to edit it, you just can't. To edit or save a document you have to click on the yellow bar that contains Enable Editing button. Once you click on that button then you can edit your document. This is basically a new security feature in Word 2010. The yellow bar on which Enable Editing button appears is known as Protected View. This feature helps in protecting your computer from any virus or any other malicious activity. Sometime, it's really frustrating to click on that yellow button whenever you open a document. If you know your files are safe and you don't need this security feature to appear then disable it.
Read more