Ошибка excel ole action

If you’ve ever encountered the «OLE action Excel» error message in Microsoft Excel, you know how frustrating it can be. This error message appears when Excel waits for another application to complete an OLE (Object Linking and Embedding) action. Fortunately, there are ways to troubleshoot and fix this error.

In this article, we’ll provide step-by-step instructions for solving the «OLE action Excel» error message in Microsoft Excel. We’ll explain what causes the error, how to identify which application is causing the issue and provide solutions to help you fix the problem.

By the end of this article, you’ll be equipped with the knowledge and tools to troubleshoot and fix the «OLE action Excel» error in Microsoft Excel. So, let’s get started and get your Excel spreadsheet back up and running smoothly.

What Is An OLE Action?

An OLE action is a feature developed by Microsoft that allows different applications to work together. OLE stands for «Object Linking and Embedding.» It lets you use part of a document from one program in another.

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

For example:

You might have a chart in an Excel spreadsheet that you want to use in a PowerPoint presentation. With OLE, you can copy the chart from Excel and paste it into PowerPoint. 

When you do this, the chart is still linked to the original Excel file, so if you make changes to the chart in Excel, those changes will be reflected in the chart in PowerPoint.

OLE also allows you to «embed» an object from one program into another. This means that the object is saved inside the program file you’re pasting it into. 

This differs from linking, where the object is still stored in the original file.

OLE is a feature that allows different programs to work together by letting you use part of a document from one program to another. It makes it easy to share information and objects between different applications.

How do I fix Microsoft Excel am waiting for another application to complete an OLE action?

If you use Microsoft Excel, you may have seen the error message «Excel is waiting for another application to complete an OLE action.» This can happen when Excel waits for another program to finish a task before it can complete its own. 

This can be frustrating, especially when trying to work on a deadline.

One possible cause of this issue is hidden links in your Excel file. These links may not be visible through the regular Excel tools, like the «Edit Links» option in the «Data» tab. They can be buried in charts or other objects copied from another file.

You can download an Excel add-in tool called «Inquire» from Microsoft to identify and remove hidden links. This tool allows you to scan your entire spreadsheet and see all the hidden links. You can then remove them to fix the issue.

To download Inquire:

1. Go to the Microsoft website and search for «Inquire add-in for Excel.» 
2. Once you download and install it, you can access it through the «Add-ins» tab in Excel. 

You can run the «Workbook Analysis» function from there to scan for hidden links.

Following these steps, you can fix the «Excel is waiting for another application to complete an OLE action» error in your Excel file.

Here’s another way

If you encounter the «Microsoft Excel is waiting for another application to complete an ole action» error message, there are several ways to fix it. Here are some possible solutions:

1. Restart your system: The first thing to try is restarting your computer and seeing if that resolves the issue.
2. Turn on the «Ignore other applications that use DDE» feature: Sometimes, the DDE protocol can cause conflicts with other applications, leading to the OLE Action Error.  To fix this, you can enable the «Ignore other applications that use DDE» feature in Excel by going to:
   — File
   — Options
   
   — Advanced
   — General
   — Select the appropriate option.
   
3. Repair or reinstall Microsoft Office: If the issue persists, try repairing or reinstalling your Microsoft Office applications to fix any corrupted files or settings.
4. Disable conflicting add-ins: Conflicting add-ins can also cause the OLE Action Error. You can try disabling them to see if that resolves the issue.
5. Check for updates: Make sure your Microsoft Office applications are current. Sometimes, updates can fix bugs or compatibility issues that may be causing the OLE Action Error.

Why Does the OLE Error Emerge?

The OLE Action Error is a message that appears when Microsoft Excel waits for another application to finish a task before it can complete its own. Here are three common reasons why this error message might appear:

1. The DDE protocol has been disabled: The DDE protocol is a communication protocol that Excel uses to exchange information with other applications. If it has been disabled, this can cause the OLE Action Error.
2. A corrupt MS Office application has been installed: If any Microsoft Office applications have been installed incorrectly or have become corrupted, this can also lead to the OLE Action Error.
3. Too many conflicting add-ins: Add-ins are extra programs that can be added to Excel to give it additional features. However, if there are too many add-ins or they conflict with each other, this can also cause the OLE Action Error.

To fix the OLE Action Error, you can try enabling the DDE protocol, repairing or reinstalling MS Office, or disabling conflicting add-ins. It’s always a good idea to save your work before attempting fixes to avoid losing progress.

What causes OLE errors in Excel?

The OLE error message in Excel means that Excel is waiting for something to finish or needs the user’s permission to complete an action. This error can happen because of different reasons, but one common cause is when another Microsoft program, like Outlook, is sending a security prompt that needs the user’s response. 

This prompt could be hiding behind another window, so it’s important to minimize all open dialogs to locate and address any open pop-up dialogs.

This error can sometimes appear because of a conflict with add-ins, a disabled DDE protocol within Excel, or when too many programs are running on the computer. To fix this issue, users can disable add-ins, enable the DDE protocol, or run Excel in safe mode. 

These solutions can help resolve the OLE error message and allow users to continue working on their Excel sheets without interruptions.

Disable add-ins

When you encounter the «Microsoft Excel is waiting for another application to complete an ole action» error message, one potential solution is to disable your add-ins. This is especially useful if you suspect that too many add-ins are running or some are corrupt.

Here are the steps to disable your add-ins:

1. Open your Microsoft Excel spreadsheet, click the File menu, and select Options.
2. From there, select Add-ins, select Excel Add-ins and click the Go button.
   
   
3. Uncheck all the boxes that you see and click OK.
   
   

Once you have disabled your add-ins, restart your Excel document to see if the error message has disappeared. If the error persists, you may need to explore other solutions, like repairing your MS Office application or reinstalling it altogether. 

Remember to save your work before attempting these solutions to avoid losing important data.

Disable Compatibility Mode

In some cases, the «Microsoft Excel is waiting for another application to complete an OLE action» error can be caused by running Excel in compatibility mode. To disable compatibility mode, follow these simple steps:

1. Right-click on your Microsoft Excel and select the Properties option.
   
   
2. An Excel options dialog box will appear.
3. Click the Compatibility mode button.
4. Uncheck the option «Run this program in compatibility mode.»

After disabling compatibility mode, restart your Excel file and check if the OLE action error message has been resolved. Disabling compatibility mode is a simple and quick solution that can potentially fix the error message.

Final Thoughts

In conclusion, the «Microsoft Excel is waiting for another application to complete an OLE action» error message can be frustrating, but there are ways to fix it. Restarting your computer, disabling add-ins, and turning on the «Ignore other applications that use DDE» feature can often help. 

Additionally, checking for and removing hidden links, disabling compatibility mode, and repairing or reinstalling Microsoft Office can solve the issue. Remember to always save your work before attempting any fixes, and if all else fails, seeking help from an IT professional or Microsoft support can provide further assistance. 

These solutions allow you to use Microsoft Excel without the pesky OLE action error message interrupting your work.

One more thing

We’re glad you’ve read this article/blog upto here Thank you for reading.

If you have a second, please share this article on your socials; someone else may benefit too. 

Subscribe to our newsletter and be the first to read our future articles, reviews, and blog post right in your email inbox. We also offer deals, promotions, and updates on our products and share them via email. You won’t miss one.

Related articles 

» How To Use NOW Function In Excel To Get Current Date And Time
» How to Merge Multiple Tables in Excel for Better Data Management
» How to use the EDATE function in Excel

Several Office users report getting the “Microsoft is waiting for another application to complete an OLE action” error when trying to run a VBA script or when trying to run Excel from a BI launch pad. The issue is reported to occur on all the recent Windows versions including Windows 7, Windows 8.1 and Windows 10)

An Object Linking & Embedding (OLE) action is essentially a mechanism designed to help various Office applications (Word, Excel, Powerpoint, Sharepoint) to communicate with other applications in order to complete an operation successfully.

What is causing the ‘Microsoft Excel is waiting for another application to complete an OLE action’ error?

We investigated this particular issue by looking at various user reports and looking at the official Microsoft documentation. We even managed to replicate the issue on one of our testing machines.

If Excel issues a communication request to another application (let’s say Word), it does it using the OLE object and then waits for the response from the application. If the response does not arrive in the default time threshold, Excel will trigger the following warning to the end user: ‘Microsoft Excel is waiting for another application to complete an OLE action’

If you’re currently struggling to resolve this particular error message, this article will provide you with a selection of troubleshooting steps. Below you have a selection of methods that other users in a similar situation have successfully used to get the issue resolved.

For the best results, follow the methods below in order until you encounter a fix that is effective in getting the issue resolved. Let’s begin

Method 1: Uninstalling  Adobe Acrobat PDFMaker (if applicable)

Some users have managed to resolve the error message by uninstalling the Adobe Acrobat PDF Maker add-in. As it turns out, this plugin has the potential to conflict with certain versions of Microsoft Excel.

Here’s a list with Office versions that are compatible with PDF Maker:

• Office 2010 (Office 14) 32 bit and 64 bit
• Office 2013 (Office 15) 32 bit and 64 bit
• Office 2016 (Office 16) 32 bit and 64 bit

Note: You can consult Adobe’s full compatibility guide (here).

If this scenario is applicable and you don’t rely on PDF Maker that heavily, you can most likely resolve the issue by either disabling or uninstalling the Adobe Acrobat PDFMaker add-in.

Here’s a quick guide on how to do this:

Update: You can also use the this Fix-it (here) to automatically disable the PDFMaker add-in automatically. It’s compatible with every recent Windows version including Windows 10, Windows 8.1, Windows 7 and Windows Vista.

1. Open Microsoft Excel and click on File using the ribbon bar.
2. From the File menu, click on Options (at the bottom of the menu list).
3. In the Excel Options menu, click on Add-ins using the left-hand side menu. Next, move over to the right-hand pane, expand the drop-down menu associated with Manage and choose COM Add-ins. Then, click the Go… button to launch the Com Add-ins menu.
4. In the COM Add-ins box, either uncheck the box associated with Acrobat PDFMaker Office COM Addin or select it and click Remove to delete it completely.
5. Restart your computer and recreate the steps that were previously producing the error once the next startup is complete.

If you’re still encountering the ‘Microsoft Excel is waiting for another application to complete an OLE action’ error, move down to the next method below.

Method 2: Allowing applications that use DDE in Excel’s settings

As a lot of users have reported, the issue might occur if Microsoft Excel is set up to ignore any applications that try to communicate with Excel using the Dynamic Data Exchange (DDE) protocol.

For example, say you double-click on an Excel workbook in Windows Explorer – as soon as the command registers, a dynamic data exchange (DDE) is sent to Excel. That exchange will instruct Excel to open the workbook that you’ve just double-clicked.

If Excel is set up to ignore applications that use the Dynamic Data Exchange protocol, the exchange will not happen and you will see the ‘Microsoft Excel is waiting for another application to complete an OLE action’ error message instead.

Luckily, you can easily rectify this issue by accessing the Options menu of Excel and enabling the DDE protocol. Here’s a quick guide on how to do this:

1. Open Microsoft Excel and click on File. It doesn’t matter if you open a new workbook or a new document.
2. In the File menu, click on Options from the left-pane.
3. In the Excel Options menu, click on the Advanced tab from the left-hand menu. Then, move over to the right pane and scroll down until you reach the General section. Once you get there, make sure that the box associated with Ignore other applications that use Dynamic Data Exchange (DDE) is unchecked.
4. Click Ok to save the changes, then restart Microsoft Excel. Then, repeat the operation that was previously causing the “Microsoft is waiting for another application to complete an OLE action” error and see if the issue is still occurring.

If you’re still encountering the same error message, move over to the next method below.

Method 3: Killing the Internet Explorer (IE) process

Several users seeing the “Microsoft is waiting for another application to complete an OLE action” error when trying to save the file, you might be seeing the error because of an IE process is interfering with the Dynamic Data Exchange (DDE) exchange.

Users in a similar situation have reported that the issue was resolved after they killed the IE process manually. Here’s a quick guide on how to do this:

1. Press Ctrl + Shift + Esc to open Task Manager.
2. Inside Task Manager, go to the Processes tab and see if you have any process belonging to Internet Explorer that is currently active.
3. If you see one open, simply right-click on it and choose End task to close it.
4. Return to Excel and see if the “Microsoft is waiting for another application to complete an OLE action” error is still occurring when you’re trying to save the file.

If you’re still encountering the same error, move down to the next method below.

Method 4: Suppressing the Excel Application Messaging

If you’re seeing the error message when trying to run a VBA script, one workaround would be to suppress the application messaging by using a tiny piece of code.

But keep in mind that this will not treat the issue itself – It’s only a workaround that prevents the error message from appearing. However, it will be helpful if your only goal is to prevent the error message from appearing.

Here’s a quick guide on inserting a VBA code to excel Workbook that will suppress the excel application messaging:

1. Open your workbook in Excel and press Alt + F11 to open the Visual Basic Editor (VBE).
2. In the Project bar (left-hand side), right-click on ThisWorkbook and choose Insert > Module.
3. In the newly created module, paste the following code (in the right section of the screen):

   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

   Update: Other users have reported that they managed to prevent the error prompt from appearing by using the following VBA code:

   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

4. Press Ctrl + S and click No when you see the “The following features cannot be saved in macro-free workbook” warning.
5. Then, choose a suitable location for the modified workbook set a proper name and make sure that the Save as type is set to Excel Macro-Enabled Workbook. Once everything is in order, click on Save to create the Excel Macro-Enabled Workbook.
6. Press Alt + Q to close the editor and go back to your workbook. Once you’re back in your editor press Alt + F8, select the Macro that you’ve just created and click Run.

Once this procedure is complete, you should no longer see the ‘Microsoft Excel is waiting for another application to complete an OLE action’ error with this WorkBook (even though it might still occur in the background).

Method 5: Disable Compatibility Mode (if applicable)

Some users have managed to resolve the issue after discovering that the Excel executable was running in Compatibility mode. This can happen due to manual user intervention or a 3rd party application.

If you suspect that Excel is running in compatibility mode, disable it and see if the  ‘Microsoft Excel is waiting for another application to complete an OLE action’ error stops appearing. Typically, the error is reported to occur if the Excel executable is configured to run in Compatibility mode with Windows Vista and older.

Here’s a quick guide on disabling Compatibility Mode:

1. Right-click the Excel executable (or the shortcut) and choose Properties.
2. In the Properties window, go to the Compatibility tab and uncheck the box associated with Run this program in compatibility mode.

Последнее обновление Ноя 12, 2021

Последнее изменение: 3 апреля 2019 г.

Чтобы исправить различные проблемы с ПК, мы рекомендуем Restoro PC Repair Tool: это программное обеспечение исправит распространенные компьютерные ошибки, защитит вас от потери файлов, вредоносных программ, сбоев оборудования и оптимизирует ваш компьютер для максимальной производительности. Исправьте проблемы с ПК и удалите вирусы прямо сейчас, выполнив 3 простых шага:

1. Загрузите Restoro PC Repair Tool, который поставляется с запатентованными технологиями (патент доступен здесь ).
2. Нажмите Начать сканирование, чтобы найти проблемы Windows, которые могут вызывать проблемы с ПК.
3. Нажмите «Восстановить все», чтобы исправить проблемы, влияющие на безопасность и производительность вашего компьютера.

• В этом месяце Restoro скачали 662 786 читателей.

Во всех приложениях появляется множество ошибок, даже в таких сторонних приложениях, как Microsoft Excel, входящие в состав пакета Office.

Ошибка, о которой мы говорим, – это печально известная ошибка «Microsoft Excel ожидает, пока другое приложение завершит действие OLE ».

Когда эта конкретная ошибка появляется на вашем дисплее, у вас есть несколько вариантов ее решения.

Как устранить ошибку «Microsoft Excel ожидает, пока другое приложение завершит действие OLE»?

1. Что такое действие OLE?
2. Почему появляется ошибка OLE?
3. Как исправить ошибку «Excel ожидает OLE»

1: Что такое OLE-действие?

Действие связывания и встраивания объектов (OLE) – это технология, позволяющая приложениям Office взаимодействовать с другими приложениями.

Это позволяет приложению для редактирования отправлять часть документа в другие приложения, а затем импортировать ее или забирать обратно с дополнительным содержимым.

2: Почему появляется ошибка OLE?

Иногда на экране может отображаться следующая ошибка, если требуемый ответ не приходит достаточно быстро: Microsoft Excel ожидает, пока другое приложение завершит действие OLE.

3 Как исправить ошибку «Excel ожидает OLE»

Первое решение – это, конечно, перезагрузить компьютер и повторить попытку. Если проблема не исчезнет, ​​попробуйте следующие обходные пути:

1 Включите функцию «Игнорировать другое приложение, использующее DDE».

1. Откройте лист Excel
2. Перейдите в меню “Файл”.
3. Нажмите на Параметры
4. Перейдите на вкладку Advanced
5. Прокрутите вниз до области «Общие» и установите флажок «Игнорировать другие приложения, использующие динамический обмен данными (DDE)».
6. Перезагрузите Excel

2 Отключить надстройки

1. Откройте лист Excel
2. Перейдите в меню “Файл”.
3. Нажмите на Параметры
4. Нажмите на надстройки
5. Выберите надстройки Excel и нажмите кнопку «Перейти».
6. Снимите все флажки и нажмите ОК.

3 Другие способы прикрепления книги Excel

Использование опции Excel «Отправить по электронной почте» может привести к упомянутой выше ошибке.

Вы можете отправить свою книгу, вложив ее в виде файла, например, в электронное письмо в Outlook или Hotmail. Вы можете использовать любое почтовое приложение, чтобы решить эту проблему.