How to Recover an Unsaved Excel Version After Choosing Not to Save
Question details
The user needs to recover an earlier version of an Excel workbook after the application closed unexpectedly or the unsaved changes were discarded.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user was working on an Excel file that closed unexpectedly, and the unsaved draft was discarded or not saved manually.
- Observed behavior
- The recent modifications or the entire workbook are missing, and the user is seeking a method to locate and restore the lost version.
Before starting the recovery process, ensure you have not cleared your temporary system files or used a PC cleaner tool, as this might permanently delete the auto-recovered Excel drafts.
Use the Recover Unsaved Workbooks Feature
Excel has a built-in feature specifically designed to rescue files that were closed without saving.
This is the most reliable method for recovering unsaved spreadsheets, provided the AutoRecover feature was active and running while you were working on the file.
Launch Microsoft Excel and click on the 'File' tab located in the top-left corner of the application.
Select 'Info' from the left-hand navigation pane, then click on the 'Manage Workbook' button to reveal a dropdown menu.
Click 'Recover Unsaved Workbooks' from the dropdown list. A file explorer dialog box will automatically open to the hidden unsaved files directory.
Select your missing file from the list and click 'Open'. Once the workbook opens in Excel, immediately click 'Save As' to store it safely on your hard drive.
Restore from OneDrive or SharePoint Version History
If your file was synced to OneDrive or SharePoint, you can revert to a previously saved version from the cloud.
Locate the Excel AutoRecover Folder Manually
If the standard recovery fails, you can manually check the hidden folder where Excel stores temporary backup files.
Prevent Data Loss with WPS Office's Smart Backup
If Microsoft Excel is unable to recover your discarded files, consider switching to WPS Office. It provides robust auto-backup features, a lightweight interface, and seamless compatibility with all Microsoft Office formats to ensure your work is always safe.
- 1. Download WPS Office: Get WPS Office for free from the official website and install it on your device.
- 2. Enable Smart Backup: Open WPS Spreadsheet, go to Menu > Settings > Backup Setting, and turn on local or cloud backup.
- 3. Edit Excel Files Seamlessly: Open your existing .xlsx files directly in WPS Office with zero formatting loss.
Frequently Asked Questions
Where are unsaved Excel files stored temporarily on my computer?
Unsaved Excel files are typically stored in the UnsavedFiles folder located at C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFiles. You can paste this path into File Explorer to manually check for missing drafts.
Can I recover an Excel file if I explicitly clicked 'Don't Save'?
It is difficult but sometimes possible. Excel's 'Recover Unsaved Workbooks' feature may retain the last auto-saved draft even if you clicked 'Don't Save', provided the AutoRecover feature was enabled and had time to run before you closed the file.
How often does Excel save AutoRecover information?
By default, Excel saves AutoRecover information every 10 minutes. You can adjust this frequency to run more often by navigating to File > Options > Save, and modifying the 'Save AutoRecover information every X minutes' setting.
Why is my 'Recover Unsaved Workbooks' list empty?
The recovery list may be empty if the AutoRecover feature was disabled, the file was not open long enough for the first auto-save interval to trigger (default is 10 minutes), or you recently cleared your system's temporary files.
