Fix Excel Worksheet Is Blank but Content Appears in File Preview
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.

- 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.
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.
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.
Launch Microsoft Excel. Click on the 'File' tab in the top left corner, then select 'Options' at the bottom of the navigation pane.
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.
Open Windows File Explorer, paste the copied path into the address bar at the top, and press Enter to navigate to the AutoRecover directory.
Look for a folder or file matching your corrupted workbook's name. Open the version with a timestamp saved right before the issue began.
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.

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. Download WPS Office: Get the free WPS Office installer from the official website and complete the quick installation.
- 2. Launch WPS Spreadsheets: Open WPS Spreadsheets, which features a familiar interface fully compatible with your existing workflows.
- 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.

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'.




