Fix Microsoft 365 Opening a Blank Window Instead of Excel 2010 Files
Question details
Users are unable to view older Excel 2010 files after upgrading to Microsoft 365, as the application launches but only shows a gray or blank screen.
- Product
- Microsoft 365 / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open legacy Excel 2010 workbooks (.xls or .xlsx) directly from the file explorer after installing Microsoft 365.
- Observed behavior
- The Excel application opens successfully but displays a completely blank window instead of loading the actual workbook data and cells.
Verify whether this issue happens with every workbook or only specific files. It is highly recommended to create a copy of a non-confidential workbook and test it locally to ensure the original file is not corrupted.
Uncheck the Ignore DDE Setting in Excel
This is the most common fix when Excel opens a blank window instead of the actual file, as incorrect Dynamic Data Exchange (DDE) settings can block the application from receiving the file content.
When you double-click an Excel file in Windows, a DDE message is sent to Excel instructing it to open the file. If Excel is configured to ignore these messages, it will launch the application but fail to load the requested workbook.
Open a blank Microsoft Excel window. Click on 'File' in the top left corner, then select 'Options' at the bottom of the left-hand menu.
In the Excel Options dialog box, click on the 'Advanced' tab on the left.
Scroll down to the 'General' section. Find the checkbox labeled 'Ignore other applications that use Dynamic Data Exchange (DDE)' and make sure it is unchecked. Click 'OK' to save your changes and try opening your Excel 2010 file again.
Verify File Associations and Extensions
Restoring the default file associations ensures that Windows is sending the correct launch command to Microsoft 365 when you open an older .xls or .xlsx file.
Disable Hardware Graphics Acceleration and Add-ins
Outdated COM Add-ins or display rendering conflicts can cause the Excel user interface to glitch and display a gray, blank background.
Open Old Excel Files Easily with WPS Office
If Microsoft 365 continues to display blank windows when opening older Excel 2010 workbooks, switch to WPS Office. It is a free, lightweight alternative that bypasses Microsoft's legacy compatibility bugs and easily handles .xls and .xlsx formats.
- 1. Download WPS Office: Visit the official WPS Office website and download the free software for your device.
- 2. Install and Launch: Run the installation file and follow the on-screen prompts to set up WPS Office.
- 3. Open Your Legacy Files: Right-click your problematic Excel 2010 file, select 'Open with', and choose WPS Office to seamlessly view and edit your data.
Frequently Asked Questions
Why does Microsoft 365 open a blank screen instead of my Excel file?
This usually happens due to incorrect Dynamic Data Exchange (DDE) settings in Excel, corrupted file associations in Windows, or outdated third-party add-ins blocking the workbook's content from rendering.
How can I tell if my older Excel 2010 file is corrupted?
Try opening the file in another spreadsheet program, like WPS Office, or uploading it to a cloud service. If the file still fails to open or displays unreadable characters everywhere, the workbook itself is likely damaged.
Does Microsoft 365 still support older .xls files?
Yes, Microsoft 365 supports legacy .xls formats. However, strict Trust Center settings may sometimes block older files in Protected View for security reasons. You can adjust this by navigating to File > Options > Trust Center > Trust Center Settings > File Block Settings.
