File Corruption & Recovery

Fix Excel Worksheet Is Blank but Content Appears in File Preview

Huda QurayshiHuda Qurayshi Oct 22, 2026 869 views

Question details

The user opens an Excel workbook but sees only a blank workspace, even though the file preview in Windows Explorer or Outlook clearly shows that the data is intact.

Fix Excel Worksheet Appearing Blank While Visible in Preview
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a saved Excel workbook or email attachment that is potentially corrupted or experiencing display glitches.
Observed behavior
The opened workbook displays no grid or data, appearing completely blank, while the file preview feature correctly renders the document's contents.
Before you start

Ensure that all currently open Excel windows are fully closed before troubleshooting. Sometimes, a temporary memory or application display glitch can cause a blank window, and simply restarting Excel resolves it.

Solution 1Recommended

Recover the Workbook Using the AutoRecover Feature

If the file is corrupted and restarting Excel does not work, you can locate and restore a previously autosaved version of the workbook from the AutoRecover folder.

Excel's AutoRecover feature automatically saves copies of your open workbooks at regular intervals. By accessing the designated AutoRecover folder, you can retrieve a healthy version of the file saved before the corruption occurred.

1
Open Excel Options

Launch Microsoft Excel. Click on the 'File' tab in the top left corner, then select 'Options' at the bottom of the navigation pane.

2
Locate AutoRecover Path

In the Excel Options window, click on the 'Save' tab in the left menu. Look for the 'AutoRecover file location' field and copy the folder path provided.

3
Access the AutoRecover Folder

Open Windows File Explorer, paste the copied path into the address bar at the top, and press Enter to navigate to the AutoRecover directory.

4
Find and Open the Backup

Look for a folder or file matching your corrupted workbook's name. Open the version with a timestamp saved right before the issue began.

5
Save the Recovered File

Once the file opens successfully and displays your data, immediately go to File > Save As and save the workbook to a new location on your computer to prevent further issues.

Recover the Workbook Using the AutoRecover Feature
Tip: Saving the recovered file under a completely new name or in a different folder ensures you do not accidentally overwrite other backups.
Free Microsoft Office alternative

Open Corrupted Workbooks Seamlessly with WPS Office

If your Microsoft Excel application frequently struggles with blank screens or corrupted files, try WPS Office. It is a highly compatible, lightweight, and completely free alternative that can often open and repair damaged files that Excel cannot.

  1. 1. Download WPS Office: Get the free WPS Office installer from the official website and complete the quick installation.
  2. 2. Launch WPS Spreadsheets: Open WPS Spreadsheets, which features a familiar interface fully compatible with your existing workflows.
  3. 3. Open the Blank File: Go to Menu > Open and select the problematic Excel file. WPS Spreadsheets can often bypass Microsoft Excel's specific display and corruption glitches to reveal your data.
Free and lightweight Microsoft Office alternativeHigh compatibility with all Microsoft Excel formats (.xlsx, .xls, .csv)Built-in intelligent file repair and document auto-backup featuresFamiliar spreadsheet interface ensuring a seamless migration with zero learning curve
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file show content in the preview pane but open as a blank sheet?

This discrepancy occurs because the preview pane reads cached thumbnails or extracts raw text, while opening the file requires Excel to fully render the workbook. If the file has minor corruption or if Excel is experiencing a display rendering glitch, the full render fails, resulting in a blank workspace.

How can I check if the workbook window is just hidden instead of blank?

Sometimes the file opens normally but the window is hidden from view. To check this, open Excel, go to the 'View' tab on the ribbon, and click 'Unhide'. If your workbook is listed in the prompt, select it and click 'OK' to make your data visible again.

Can hardware graphics acceleration cause a blank Excel screen?

Yes, display driver conflicts with Excel's hardware graphics acceleration feature can cause workbooks to appear blank. You can potentially fix this by navigating to File > Options > Advanced, scrolling down to the 'Display' section, and checking the box for 'Disable hardware graphics acceleration'.