Fix Excel Opening Document Recovery and Gray Screen for Network Files
Question details
Resolve an issue where Excel automatically opens the Document Recovery pane and displays a blank gray screen instead of the expected workbook.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accessing and opening Excel workbooks hosted on a shared network drive.
- Observed behavior
- Excel displays a gray screen and unexpectedly opens the Document Recovery pane, failing to load the requested network workbook properly.
Ensure your network connection is stable and that you have the appropriate read/write permissions to access files on the mapped network drive before proceeding.
Clear the Local AutoRecover Folder
Delete old or stuck recovery files that Excel might be incorrectly attempting to reference when launching network files.
Often, a corrupted or stranded recovery file saved on your local drive forces Excel into a recovery loop, preventing network workbooks from rendering correctly.
Open Excel and navigate to File > Options > Save. Look for the 'AutoRecover file location' field and copy the folder path displayed there.
Close Excel completely. Open Windows File Explorer, paste the copied path into the address bar, press Enter, and delete all the files inside this folder.
Reopen Excel and try accessing your network workbook again to confirm that the gray screen and Document Recovery pane no longer appear.

Temporarily Disable AutoRecover Information
Turn off the AutoRecover feature to prevent Excel from attempting to save or load recovery states, bypassing the startup error.
Try WPS Office for Seamless Network File Management
If Microsoft Excel continues to freeze, show gray screens, or enter recovery loops when accessing network drives, consider switching to WPS Office. It is a highly compatible, free, and lightweight alternative that easily handles large workbooks from network locations without unexpected glitches.

Frequently Asked Questions
Why does Excel show a gray screen when opening network files?
A gray screen usually indicates that the Excel application framework has opened, but the workbook data failed to render. This often happens due to network latency, hidden background dialog boxes, corrupted display add-ins, or the application getting stuck trying to load a corrupt AutoRecover file.
Where are Excel AutoRecover files saved by default?
By default in Windows, Excel saves AutoRecover files in 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\'. You can verify your exact local path by checking File > Options > Save.
Will deleting an .xlb file help fix Excel gray screens?
Yes, sometimes. The Excel15.xlb file (or similar, depending on version) stores custom toolbar and command-bar settings. If this file gets corrupted, it can cause display anomalies. Renaming or deleting it forces Excel to rebuild a fresh default file on the next launch, potentially fixing the issue.




