Excel

Excel File Opens But Shows Empty Sheets

Excel launches, the file appears to open, but the window is empty — no data, no sheets, just a blank grey background or an apparently empty workbook. This is rarely actual data loss. In most cases the data is still there; Excel just isn’t showing it. Try the display fixes first, in order. If the data really is missing, the structural recovery section covers that.

Quick fix

Reveal hidden workbook windows.

  1. With Excel still showing the empty workbook, go to the View tab.
  2. Click Unhide in the Window section.
  3. If a list appears, select the workbook name and click OK.

If Unhide is greyed out, no hidden workbook windows exist — move on to the next strategy. If Unhide reveals your data, the file was opened with the workbook window hidden, usually due to a previous save that left it that way. Save again now and the issue won’t recur.

If that didn’t work

Toggle the DDE setting

When Excel is set to ignore Dynamic Data Exchange messages, double-clicking a file in Explorer launches Excel without telling Excel which file to open. The result is an empty Excel window with no workbook loaded — even though the file name appears in the title bar.

  1. With Excel open, go to File > Options > Advanced.
  2. Scroll down to the General section.
  3. Find the checkbox Ignore other applications that use Dynamic Data Exchange (DDE).
  4. Untick it.
  5. Click OK and try opening the file again.

This is the single most common cause of “Excel opens to nothing” when double-clicking files. It often gets enabled accidentally as part of troubleshooting unrelated issues, then forgotten.

Restore an off-screen window

Workbooks remember their window position when saved. If a workbook was saved with its window positioned on a second monitor that’s no longer attached, the window opens off-screen and you see only the Excel chrome.

  1. With the workbook open and the window invisible, ensure Excel is the focused application.
  2. Press Alt+Space to open the window menu, then press M for Move.
  3. Press an arrow key once.
  4. Move the mouse — the window will follow your cursor regardless of its actual position. Bring it to your visible screen and click to place it.
  5. Save the file to update the stored window position.

Try Excel safe mode

If neither display fix worked, an add-in may be suppressing the workbook view. Launch Excel in safe mode:

  1. Press Win+R to open the Run dialog.
  2. Type excel /safe and press Enter.
  3. From safe-mode Excel, open the file via File > Open.

If the data appears in safe mode, an add-in is the cause. Close safe mode, restart Excel normally, and disable add-ins one at a time via File > Options > Add-ins > Manage > COM Add-ins > Go until the issue stops.

Advanced recovery

If the above strategies all show the data is genuinely missing — not just hidden — the file’s internal structure is damaged. XLSX files store cell text values in a separate part called sharedStrings.xml. When that part is damaged, sheets display as empty even though their structure is intact.

Run Open and Repair

The first structural attempt is Excel’s built-in repair feature.

  1. In Excel, go to File > Open > Browse.
  2. Click the file once to select it (do not double-click).
  3. Click the arrow next to the Open button at the bottom of the dialog.
  4. Choose Open and Repair > Repair. If Repair fails, run again and choose Extract Data.

Extract Data salvages cell values without trying to restore formatting, formulas, or pivot structures.

Inspect the XLSX as a ZIP archive

If Open and Repair recovers nothing, examine the file’s internal structure:

  1. Make a copy of the file with a .zip extension.
  2. Open the copy with 7-Zip or another archive tool.
  3. Look for xl/sharedStrings.xml and xl/worksheets/sheet1.xml (sheet2.xml, etc., for additional sheets).

If sharedStrings.xml is missing or zero bytes, that confirms the diagnosis — the string table that holds your text data is gone, but the cell positions and numeric data may still be in the sheet XML files. If sheet1.xml is also empty or missing, the data itself is gone, not just the index to it.

For string-table damage with intact sheet files, opening the file in LibreOffice Calc sometimes succeeds where Excel fails — Calc reconstructs missing references differently than Excel does. If Calc opens it, save as a new XLSX and test in Excel.

For data that’s genuinely missing from the sheet files, the recovery options narrow significantly. Check OneDrive or SharePoint version history if the file was synced — a previous version may still be intact. Check the AutoRecover folder (typically %AppData%\Microsoft\Excel\) for a recent backup. If neither produces a working version, the data is unlikely to be recoverable.

Why this happens

The “empty workbook” symptom has two distinct root causes that look identical to the user but require completely different fixes.

Display issues (most common). The data is intact in the file. Excel is opening it. But Excel isn’t showing it because of a window state setting, a DDE configuration, an add-in, or a saved window position that puts the workbook off-screen. Display issues account for the large majority of reports of this symptom and are resolved by the Quick Fix and “If that didn’t work” sections above. The Open and Repair / structural recovery path is unnecessary for these cases.

Damaged shared strings table (less common). XLSX files store unique text values in xl/sharedStrings.xml, with each cell in the worksheet referencing strings by index. This compression makes XLSX files dramatically smaller than they would be if every cell stored its text directly, but it creates a single point of failure. If sharedStrings.xml is damaged, every cell that references it shows as empty when displayed, even though the cell itself is intact. Numeric cells are unaffected — they store their values directly in the sheet XML — so a partially-empty workbook with numbers in some cells and blanks where text should be is the diagnostic signature.

Save errors creating empty files. A power loss or crash during save can produce an XLSX that opens cleanly but contains no data. The file structure validates, but the sheets are genuinely empty. Recovery here depends entirely on whether you have an earlier version saved or backed up.

Preventing this in future

Two settings, applied once, prevent the most common version of this problem.

In File > Options > Advanced, leave Ignore other applications that use Dynamic Data Exchange (DDE) unticked. This is the default; only tick it as a deliberate troubleshooting step, and untick it when you’re done.

When working across multiple monitors, save workbooks with their windows positioned on your primary display. The window position saved with the file is what determines where it opens later — including on machines where the second monitor isn’t attached.

For the structural cause, normal backup discipline applies. OneDrive or SharePoint version history, paired with regular auto-save intervals, makes this kind of damage recoverable in seconds rather than not at all.

If Excel refuses to open the file at all rather than opening to an empty workbook, see Excel file won’t open — different symptom, different fix path. If Excel crashes during open, Excel crashes when opening a file covers the diagnostic steps. For damaged content that triggers Excel’s recovery prompt rather than silently producing an empty workbook, see Excel found unreadable content.

Last verified: April 2026