Many users report the "Microsoft Excel waits for another application to complete an OLE action“In Windows 10 when using Office applications. For example, you may encounter this error when trying to open Excel using a BI launch pad or when trying to run a VBA script.
Microsoft introduced Object Linking and Embedding (OLE) technology to help Office applications communicate with other programs. Using this technology, an editing program to share a section of a document with other programs and then import the section of the document or bring it back with the other program's content.
So, for example, if you are working in Excel and trying to interact with Word, it will send a message to the OLE object and wait until it gets a response from Word. However, when the response is delayed beyond the required time, you will see the message "Microsoft Excel waits for another application to complete an OLE action"Error.
The error may appear due to the DDE protocol being disabled in Excel, when the Office suite installation is corrupted, if you have Adobe Acrobat PDFMaker add-in and it interferes with Excel, or if Internet Explorer conflicts with Excel. While excelling completely shut down, restarting your computer and restarting can help, you can also try the methods below in case it doesn't.
Method 1: removing Adobe Acrobat PDFMaker
Adobe acrobat PDFMaker is known to have incompatibility issues with MS Excel. Thus. It is recommended to activate the plugin. Let's see how.
Step 1: Launching Stand out and go to archive tab in the upper left corner of the sheet.
Step 2: From archive menu, select options.
Step 3: A Excel options dialog box, click Accessories on the left side of the panel.
Now go to the right side of the window and find the file Manage down option. Please select COM plugin in the drop-down menu next to it and press the key Andiamo button.
Step 4: Now in COM additional box that appears, deselect the Acrobat PDFMaker Office COM Add-in and press ok to save changes and exit.
Now restart your PC and try to open Excel again or run the VBA script to check if the error is gone. If the problem persists, try the second method.
Method 2: Allowing other applications that use DDE
Step 1: Open Stand out and go to archive tab at the top left of the screen.
Step 2: Please select options from archive menu.
Step 3: A Excel options window, go left and click Advanced. Now on the right side scroll down and find the file general section.
Here, uncheck the box next to Ignore other applications that use Dynamic Data Exchange (DDE).
print ok to save changes and exit.
Now, go back and try the same operation you were doing earlier and see if the error is still there. If you still see the error, try the third method.
Method 3: End the Internet Explorer process
Step 1: Navigate to Application bar and right click on it. Please select Task Manager give the menu answer.
Step 2: A Task Manager window under the Processes tab, find and select the file Processo di Internet Explorer. Then press the button Final task at the bottom left of the window.
Go back to Excel and see if the error is gone. If you still find the error, try the fourth method.
Method 4: Restrict Messaging from Excel Application
Try this method if you find the "Microsoft Excel waits for another application to complete an OLE action“Error while running a VBA script. However, this is only a solution and does not solve the problem itself. But it can help you by running the VBA script for now and blocking the error message. Here's how to do it.
Step 1: Open an Excel sheet and press the button Press Alt + F11 together on the keyboard to open the file Microsoft Visual Basic for Applications editor window.
Step 2: A Project - VBA Project left bar, search This workbook under Microsoft Excel objects.
Right click on it, go to To insert from the context menu and from the submenu select Module.
Step 3: Create a new one Module on the right side of the panel. Copy the following code and paste it into the module:
Private Declare Function CoRegisterMessageFilter Lib "ole32" (ByVal IFilterIn As Long, ByRef PreviousFilter) As Long Public Sub KillMessageFilter() Dim IMsgFilter As Long CoRegisterMessageFilter 0&, IMsgFilter End Sub Public Sub RestoreMessageFilter() Dim IMsgFilter As Long CoRegisterMessageFilter IMsgFilter, IMsgFilter End Sub
Step 4: Alternatively, you can also copy the following code and paste it into the new module. Both codes will work.
Sub CreateXYZ() Dim wdApp As Object Dim wd As Object On Error Resume Next Set wdApp = GetObject(, "Word.Application") If Err.Number <> 0 Then Set wdApp = CreateObject("Word.Application") End If On Error GoTo 0 Set wd = wdApp.Documents.Open(ThisWorkbook.Path & Application.PathSeparator & "XYZ template.docm") wdApp.Visible = True Range("A1:B10").CopyPicture xlScreen wd.Range.Paste End Sub
Step 5: Now go to archive tab in the upper left corner of the editor and select Save book 1.
Step 6: After pressing the button Save button, you will see a message that says, The following functions cannot be saved in workbooks without macros.
press the No button.
Step 7: Now, select the location where you want to save this book, create a file file nameand set the Save as type similar field Macro-enabled Excel workbook.
Click on Save to save the new VBA workbook.
Step 8: After saving the VBA file, close the editor and go back to the file Stand out workbook. Here, press Alt + F8 keys together on the keyboard. From Macro dialog box, select the file Macro just created and press the button run button.
Now that you have successfully completed the process, you should no longer see the error. However, if you keep getting the error then try the fifth method.
Method 5: turn off Excel compatibility mode
Step 1: Go to MS Excel application on the desktop, right-click and select Property in the context menu.
Step 2: A Microsoft Excel properties dialog box, go to Compatibility language. Now go to the file Compatibility mode section and uncheck the box next to Run this program in compatibility mode on.
print To apply and so ok to save changes and exit.
That's all. You can try to repeat the above operation in Excel and you should no longer see the "Microsoft Excel waits for another application to complete an OLE actionOn your Windows PC while running a VBA script or opening Excel.
