File Cannot Open

How to Fix Excel 365 File Opening as a Blank Worksheet

Natalie TaylorNatalie Taylor Oct 19, 2026 873 views

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.

How to Fix Excel 365 File Opening as a Blank Worksheet
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.
Before you start

Ensure your Microsoft 365 subscription is active and restart your computer to rule out any temporary background glitches before attempting advanced troubleshooting.

Solution 1Recommended

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.

1
Initiate Safe Mode

Press and hold the Ctrl key on your keyboard, then click the Excel shortcut to launch the application.

2
Confirm Prompt

A window will pop up asking if you want to start Excel in Safe Mode. Click 'Yes'.

3
Open the File

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.

4
Disable Add-ins

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.

Launch Excel in Safe Mode to Disable Add-ins
Safe Mode Verified: If the file opens successfully in Safe Mode, the workbook itself is not corrupted, and your data is safe.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download the free office suite and follow the quick installation prompts.
  2. 2. Launch WPS Spreadsheet: Open the WPS Spreadsheet application from your desktop or start menu.
  3. 3. Open Your Workbook: Drag and drop your problematic Excel file into the WPS workspace to instantly view and edit your data.
Completely free and lightweight with no heavy background updates requiredSeamless format compatibility with Microsoft Excel (.xls, .xlsx, .csv)Familiar ribbon user interface allowing for zero learning curveStable performance that is less prone to third-party add-in crashes
microsoft office alternative - wps office

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.