Fix Excel OLE Action Error When Opening XLS Files from SharePoint
Question details
A user experiences an OLE action error when attempting to open macro-enabled .xls files directly from a SharePoint environment.

- 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.
Ensure your network connection to the SharePoint server is stable and save any unsaved work in other open applications before troubleshooting.
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.
Type 'msconfig' in the Windows Start menu search bar and press Enter to open the System Configuration utility.
Navigate to the 'Services' tab, check the box for 'Hide all Microsoft services' at the bottom, and then click the 'Disable all' button.
Go to the 'Startup' tab and click 'Open Task Manager'. In Task Manager, right-click each enabled startup item and select 'Disable'.
Close Task Manager, click 'OK' on the System Configuration window, and restart your computer. Try opening the .xls file from SharePoint again.

Disable Dynamic Data Exchange (DDE)
Disabling the DDE feature in Excel can prevent the application from waiting on unresponsive external commands.
Download the File Locally
Bypassing the server-side OLE timeout by downloading the file circumvents the synchronization error entirely.
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. Download WPS Office: Visit the official WPS website and download the free WPS Office installer.
- 2. Install the application: Run the installer and follow the on-screen prompts to set up WPS Office on your Windows PC.
- 3. Open your spreadsheet: Launch WPS Spreadsheet, open your downloaded .xls file, and seamlessly run your macros.

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.




