Excel Error Codes

Fix Excel OLE Action Error When Opening XLS Files from SharePoint

John WilsonJohn Wilson Nov 3, 2026 870 views

Question details

A user experiences an OLE action error when attempting to open macro-enabled .xls files directly from a SharePoint environment.

How to Fix Excel OLE Error When Opening SharePoint XLS Files
Product
Microsoft Excel
Device & OS
Windows
Scenario
Opening macro-enabled legacy .xls documents stored on a SharePoint server for individual use.
Observed behavior
Excel displays the error message 'Microsoft Excel is waiting for another application to complete an OLE action' and fails to load the file, even though the file opens perfectly when saved locally.
Before you start

Ensure your network connection to the SharePoint server is stable and save any unsaved work in other open applications before troubleshooting.

Solution 1Recommended

Perform a Windows Clean Boot

Since the issue typically affects isolated users, a background application or service may be conflicting with Excel's connection to SharePoint.

A clean boot starts Windows with a minimal set of drivers and startup programs. This helps eliminate software conflicts that occur when you install a program or an update, or when you run a program in Windows.

1
Open System Configuration

Type 'msconfig' in the Windows Start menu search bar and press Enter to open the System Configuration utility.

2
Disable non-Microsoft services

Navigate to the 'Services' tab, check the box for 'Hide all Microsoft services' at the bottom, and then click the 'Disable all' button.

3
Disable startup programs

Go to the 'Startup' tab and click 'Open Task Manager'. In Task Manager, right-click each enabled startup item and select 'Disable'.

4
Restart and test

Close Task Manager, click 'OK' on the System Configuration window, and restart your computer. Try opening the .xls file from SharePoint again.

Perform a Windows Clean Boot
Re-enabling Services: If the error is resolved, you can use the System Configuration utility to turn services and startup programs back on one at a time to isolate the exact cause.
Free Microsoft Office alternative

Open Macro-Enabled Spreadsheets Seamlessly with WPS Office

If Microsoft Excel continues to display OLE errors with legacy .xls files from SharePoint, consider switching to WPS Office. It provides robust support for older formats and complex macros without the heavy background processes that trigger OLE timeouts.

  1. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
  2. 2. Install the application: Run the installer and follow the on-screen prompts to set up WPS Office on your Windows PC.
  3. 3. Open your spreadsheet: Launch WPS Spreadsheet, open your downloaded .xls file, and seamlessly run your macros.
Fully compatible with Microsoft Excel formats, including .xls, .xlsx, and .xlsm.Built-in support for executing VBA macros smoothly and securely.Lightweight architecture ensures faster startup and eliminates OLE connection timeouts.Free to use with a familiar, easy-to-navigate interface.
microsoft office alternative - wps office

Frequently Asked Questions

What does 'Excel is waiting for another application to complete an OLE action' mean?

This error occurs when Excel sends a command to another application or background service (such as an anti-virus scanner or a cloud synchronization tool) and does not receive a response within a designated timeframe.

Why does the OLE error only affect older .xls files?

Legacy .xls files, especially those containing macros, use older processing protocols. When combined with modern cloud environments like SharePoint, these older protocols can sometimes miscommunicate with background synchronization services, resulting in a timeout error.

Will disabling DDE in Excel affect my other files?

Checking the 'Ignore other applications that use DDE' option generally improves file opening performance and resolves OLE errors without negatively impacting standard spreadsheet functions. However, if you use automated scripts that rely on DDE to send data directly into Excel, you may need to leave it enabled.