How to Recover an Unsaved Excel Workbook That Cannot Be Found
Question details
The user needs to locate and recover an important unsaved Excel file and determine if an AutoRecover copy exists.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user accidentally closed an Excel workbook without saving and cannot find it using standard recovery methods.
- Observed behavior
- The unsaved Excel workbook is missing, and standard recovery options are not displaying the file in the recent lists.
Ensure you have not run any system cleaning software or emptied your Recycle Bin recently, as this might permanently delete temporary AutoRecover files.
Check the 'Recover Unsaved Workbooks' Directory
Use Excel's built-in feature designed to locate and restore recently closed files that were not saved.
Excel keeps temporary copies of your unsaved files in a specific system folder if the AutoRecover feature is active. Accessing this folder directly through Excel is the most reliable way to retrieve lost work.
Launch Microsoft Excel. Click on the 'File' tab in the top-left corner and select 'Open', then choose 'Recent'.
Scroll all the way to the bottom of your recent workbooks list and click the 'Recover Unsaved Workbooks' button.
A file explorer window will open. Look for your missing file, select it, and click 'Open' to restore it.

Use the Document Recovery Pane
Check the Document Recovery pane that automatically appears when Excel restarts after an unexpected crash or closure.
Prevent Future Data Loss with WPS Office
Tired of losing your unsaved work when Excel crashes? WPS Office provides a lightweight, highly compatible, and free alternative with intelligent auto-backup features to ensure your spreadsheets are always safe.

Frequently Asked Questions
Where are AutoRecover files stored in Windows?
By default, AutoRecover files in Microsoft Office are saved in a hidden system directory located at 'C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\'. You can paste this path into Windows File Explorer to check it manually.
Why didn't Excel create an AutoRecover copy?
AutoRecover only saves files at specified intervals (usually every 10 minutes by default). If you closed the file before the first interval triggered, or if the AutoRecover setting was disabled, no temporary copy will be created.
How do I enable AutoSave to prevent future data loss?
Go to File > Options > Save. Ensure that both 'Save AutoRecover information every X minutes' and 'Keep the last AutoRecovered version if I close without saving' are checked. Adjust the minutes to a smaller number for more frequent backups.




