The Excel OLE action error means Excel is waiting for another program to respond, usually an app or add-in that Excel is trying to communicate with. First, switch to the other program and respond to any open prompt; if there is none, save what you can, then troubleshoot the workbook, add-ins, and Office installation in that order.
What the OLE action error means
OLE stands for Object Linking and Embedding, a Windows technology that lets applications share information or work together. Excel may use this kind of communication when a workbook contains an object from another program, when an add-in automates another application, or when a separate program asks Excel to perform an action. The message commonly says, “Microsoft Excel is waiting for another application to complete an OLE action.” It is a status warning about a delayed response, not a diagnosis of one particular fault.
The other program might be Word, a PDF editor, a web browser, Outlook, or specialist business software. Excel can appear frozen while it waits, even though the other application is the one that needs attention. A hidden confirmation box, sign-in prompt, or security dialog can hold up the exchange. In other cases, the program has stopped responding, an add-in is stuck, or a workbook is repeatedly requesting information from an external source.
OLE is not the same thing as Dynamic Data Exchange, or DDE. Both are ways for Windows programs to communicate, but they are distinct technologies. Changing Excel’s DDE setting is therefore not a universal fix for an OLE warning.
What to do when the message appears
Start with the least disruptive checks. Avoid immediately closing Excel or ending a task: doing so can discard unsaved work, and the warning may clear as soon as the other program finishes.
- Give it a moment. A large file, slow external service, or busy application can take time to respond. If the workbook is processing a known task, wait briefly before intervening.
- Look for a prompt in another app. On Windows, use Alt+Tab to cycle through open windows, or check the taskbar for a flashing application. A dialog may be behind Excel. Read the prompt and choose the appropriate response rather than dismissing it automatically.
- Check whether the other app is responsive. Try interacting with its window. If it is working, let the action finish. If it has its own error or sign-in request, resolve that first.
- Save the workbook if Excel allows it. Use Ctrl+S on Windows. On Mac, use Command+S. If Excel is completely unresponsive, these shortcuts may not work; avoid repeatedly pressing keys that could trigger unintended actions.
- Close the stalled operation carefully. If Excel recovers, close the relevant document or app normally and reopen the workbook. Use Task Manager only when an application is genuinely unresponsive and cannot be closed normally; unsaved changes may be lost.
On a Mac, Command+Tab switches applications, and Option+Command+Esc opens the Force Quit window. OLE is primarily a Windows inter-application technology, so a Mac user seeing a similarly worded message should also note the exact text and identify any add-in or external application involved. Excel for the web runs in a browser and does not provide the same Windows OLE automation environment.
Find out whether the workbook or Excel is the cause
A quick comparison can narrow the search. Open a blank workbook and repeat the action that caused the warning, if it is safe to do so. Then open the problem file again without repeating that action. If only one workbook triggers the error, inspect its linked objects, external connections, macros, or add-ins used by that file. If multiple unrelated workbooks trigger it, look more closely at Excel’s add-ins, Office installation, or the other program.
Also consider what happened immediately before the warning. Did you click a button that opens a PDF, run a macro that controls another application, refresh external data, or double-click an embedded object? A repeatable connection between one action and the message is useful evidence. For example, if the warning occurs only when opening an embedded chart in another program, that program’s availability and responsiveness are more relevant than Excel’s calculation settings.
If a file came from email or the web, treat it cautiously. Do not enable macros or approve an external connection simply to make the warning disappear. Only allow content when you trust the source and understand what the workbook is expected to do.
Test Excel add-ins
Add-ins extend Excel, but a faulty or incompatible add-in can delay requests to another application. To check whether one is involved, start Excel in Safe Mode on Windows: press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with many customizations and add-ins disabled. Open a copy of the affected workbook and see whether the same action still produces the warning. Safe Mode is a diagnostic test; it does not repair or permanently change the workbook.
If the problem disappears in Safe Mode, review add-ins in normal Excel. Select File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins, then choose Go. Record which items are selected, clear the check boxes to temporarily disable them, and restart Excel. If that helps, re-enable add-ins one at a time, restarting and testing after each change, to identify a likely cause. You can use the same Manage area to inspect Excel add-ins.
Do not remove an add-in just because it is unfamiliar. Some are installed by workplace systems or required for specialized functions. If the workbook belongs to an organization, ask its support team before disabling a business-critical extension. Excel for Mac has its own add-in controls, and the Windows COM Add-ins steps do not apply there.
Check the other application and external content
When the warning follows an action involving a second program, confirm that the program is installed, open, signed in if required, and not waiting for a dialog. If the action depends on a file location, check that the file is accessible. A network location or cloud service that is temporarily unavailable can delay a request even when Excel itself is functioning normally.
Workbooks can contain linked or embedded objects. A linked object depends on its source file remaining available; an embedded object is stored within the workbook, although opening or editing it can still call the program that handles that object type. If the issue occurs when you select one particular object, avoid repeatedly activating it. Check whether the relevant source application opens normally on its own, and ask the workbook’s owner whether the object is expected to be used.
For external data, identify the connection before changing refresh settings. A workbook may be set to refresh data when opened or when a user requests a refresh, and the source may require credentials or a network connection. If you do not recognize the source, do not supply credentials or enable connections without verifying the workbook’s origin.
Review DDE and other Excel settings carefully
Excel for Windows includes a DDE option at File > Options > Advanced > General, labeled Ignore other applications that use Dynamic Data Exchange (DDE). This setting controls DDE requests; it does not directly turn OLE on or off. If it is selected, some applications that rely on DDE to communicate with Excel may not work as expected. Changing it may help diagnose a DDE-specific problem, but it should not be treated as the standard cure for an OLE action message.
Before changing this option, consider whether your work depends on another program sending data to Excel through DDE. If you are unsure, leave the setting as it is and consult the software provider or workplace administrator. Avoid changing registry values or downloading “repair” utilities suggested by unrelated websites. Those steps can create additional problems and are not necessary for ordinary troubleshooting.
Update or repair Office if the issue persists
If the warning affects several workbooks and remains after add-ins and external applications have been checked, install available Office updates. In Microsoft 365 desktop apps, select File > Account > Update Options > Update Now, when that option is available. Some work or school installations are managed by an administrator, so update controls may be restricted or labeled differently.
On Windows, you can also use the installed-app repair options: open Windows Settings, go to Apps > Installed apps (the wording can vary by Windows release), select Microsoft 365 or Microsoft Office, choose Modify, and follow the repair choices shown. An online repair may take longer and require an internet connection. Save and close Office files first, and follow the prompts; repair availability and labels can differ by installation type. If the device is managed by an organization, check with IT before repairing or changing the installation.
Repair is more appropriate when the problem affects Excel broadly, not just one workbook or one external application. If only one third-party program causes the warning, updating or repairing that program may be more relevant than repairing Office.
When to wait, close Excel, or ask for help
Waiting is reasonable when Excel has just started a known task and the other application is still responding. Close the involved program normally when it displays a clear error or has finished the request. If the same message returns every time you open one workbook, stop repeating the triggering action and work from a separate copy while investigating. That preserves the original and reduces the risk of damaging a file that contains important data.
Use Task Manager on Windows only if an application is not responding and normal closing methods fail. Press Ctrl+Shift+Esc to open Task Manager, identify the unresponsive application, and end it only when you accept that unsaved changes in that application may be lost. On Mac, Force Quit is opened with Option+Command+Esc, but that is not a direct solution to Windows OLE. If a work computer or business workbook is involved, provide support staff with the exact message, workbook name, action that triggers it, Excel version, and whether Safe Mode changes the result.
The error does not, by itself, prove that a workbook is corrupt, that a virus is present, or that Excel needs reinstalling. It says that a communication request has not completed. Those broader conclusions require separate evidence.
Frequently Asked Questions
What does “Excel is waiting for another application to complete an OLE action” mean?
Excel has sent or is handling a request involving another program and has not received a completed response yet. The other program may need attention, may be slow, or may have stopped responding.
How do I stop the OLE action error in Excel?
First switch to the other open applications and respond to any hidden prompt. If the error keeps returning, test the workbook in Excel Safe Mode, temporarily disable add-ins, and check the external app or data source involved in the action.
Is the Excel OLE error caused by a virus?
Not on its own. The message describes delayed communication between applications and is commonly related to a prompt, add-in, or unresponsive program. Use your organization’s security process if you have separate reasons to distrust the workbook, and do not enable unknown macros or connections.
Should I turn off “Ignore other applications that use DDE”?
Not automatically. That checkbox affects DDE, a different communication method from OLE. Change it only when diagnosing a DDE-related integration issue and after checking whether your workflow depends on DDE.
Can I fix this error in Excel for the web or on a Mac?
Excel for the web does not use Windows OLE automation in the same way as desktop Excel. On Mac, try switching to the other application, checking add-ins, and recording the exact message; Windows-specific COM Add-ins, Safe Mode, and OLE troubleshooting steps may not apply.
Related
- Identify Circular References in Excel: A Step-by-Step Guide
- Enable Circular References in Excel: Step-by-Step
- Find Circular References in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- TRIM Excel Not Working? Fix Spaces That TRIM MissesIf TRIM appears not to work in Excel, the text may contain a character that TRIM does not…
- Excel Math Not Working? Fix Formula and Calculation ErrorsIf Excel math is not working, first make sure the cell contains a formula beginning with =, then…
- Mode Not Working in Excel? Causes, Checks and FixesIf MODE is not working in Excel, the most common reason is that the selected range contains no…
- Excel Merged Cells Error: Fix the Size Mismatch FastThe Excel message “To do this, all the merged cells need to be the same size” means the…
- Excel Text Box Disappeared? How to Find and Restore a Missing BoxAn Excel text box that disappears is often still in the workbook: it may be hidden in the…
- Excel Copy and Paste Not Same Size? Fix the ErrorExcel displays the copy-and-paste size error when the copied cells and the selected destination do not have a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.