How to Fix Excel 365 File Opening as a Blank Worksheet
Question details
The user is unable to view the data of an important Excel 365 file because it opens as a completely blank worksheet, while other Excel files function normally.

- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Attempting to open and access data within a specific Excel workbook for work or personal use.
- Observed behavior
- The Excel application launches successfully, but it fails to load the file's contents, displaying a blank grid or grey screen instead of the expected data.
Ensure your Microsoft 365 subscription is active and restart your computer to rule out any temporary background glitches before attempting advanced troubleshooting.
Launch Excel in Safe Mode to Disable Add-ins
Opening Excel in Safe Mode bypasses customized settings and third-party add-ins, helping you identify if a conflict is causing the blank worksheet.
Often, outdated or conflicting third-party COM add-ins can interfere with how Excel renders a file. Safe mode temporarily disables these extensions.
Press and hold the Ctrl key on your keyboard, then click the Excel shortcut to launch the application.
A window will pop up asking if you want to start Excel in Safe Mode. Click 'Yes'.
Go to File > Open and browse for your problematic Excel file. If it opens correctly with your data visible, an add-in is likely the cause.
To fix this permanently, go to File > Options > Add-ins. Manage your COM Add-ins by unchecking them one by one until you find the culprit.

Repair Your Microsoft Office Installation
Use the built-in Windows repair tool to fix missing or corrupted Microsoft 365 program files that might be preventing Excel from functioning normally.
Use the Open and Repair Feature
If only one specific file is affected and Safe Mode does not resolve the issue, the file may be corrupted and require Excel's built-in repair utility.
Open Your Excel Files Smoothly with WPS Office
If Microsoft Excel 365 continues to experience add-in conflicts or requires tedious system repairs, try WPS Office. It is a highly compatible, free, and lightweight alternative that flawless opens, edits, and saves .xlsx workbooks without the typical Microsoft environment glitches.
- 1. Download and Install: Visit the official WPS website to download the free office suite and follow the quick installation prompts.
- 2. Launch WPS Spreadsheet: Open the WPS Spreadsheet application from your desktop or start menu.
- 3. Open Your Workbook: Drag and drop your problematic Excel file into the WPS workspace to instantly view and edit your data.

Frequently Asked Questions
Why does my Excel file open as a completely blank grey screen?
A blank grey screen in Excel often occurs if the 'Ignore other applications that use Dynamic Data Exchange (DDE)' setting is enabled, if hardware graphics acceleration is causing display bugs, or if the workbook window was accidentally saved in a hidden state.
How do I unhide an Excel workbook if it opens blank?
Open Excel, navigate to the 'View' tab on the top ribbon, and look for the Window group. Click on 'Unhide'. If your file is listed in the pop-up dialog box, select it and click OK to restore visibility to your spreadsheet data.
Is it possible that third-party add-ins are causing the blank worksheet issue?
Yes, outdated or conflicting COM add-ins can intercept file load commands and prevent Excel from rendering the file's contents properly. Starting Excel in Safe Mode by holding the Ctrl key during launch allows you to verify if an add-in is the root cause.
Can I recover my data if the Excel file is permanently corrupted?
Yes, if Excel's native 'Open and Repair' feature fails, you can try opening the file in a highly compatible alternative spreadsheet program like WPS Office, restoring a previous file version from OneDrive, or using the 'Extract Data' option in Excel to salvage raw values.




