How to Recover a Newer Excel Version After Choosing the Wrong AutoRecover File
Question details
The user selected the wrong file in Excel's Document Recovery pane and needs to find and restore the newer, unsaved version of their workbook.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to recover unsaved spreadsheet data after a crash or accidental closure by using the Document Recovery pane.
- Observed behavior
- The user accidentally clicked on an older file version in the AutoRecover pane, potentially losing the more recent changes that were captured.
Do not save or close the current Excel workbook, as doing so might overwrite existing backup files or erase your cloud version history.
Restore from OneDrive Version History
If your file is synced to OneDrive or SharePoint, Excel automatically saves versions of your document. This is the most reliable way to recover the lost newer version.
OneDrive and SharePoint continuously log changes made to your files. Reverting to a previous version is the fastest way to undo the mistake of picking the wrong AutoRecover file.
Click the file name at the top of the Excel window and select "Version History" from the drop-down menu. Alternatively, go to File > Info > Version History.
Review the list of saved versions in the right-hand pane, which are organized by date and time.
Locate the most recent timestamp before the wrong AutoRecover file was selected, and click "Open version" below it.
A yellow banner will appear at the top of the opened file. Click "Restore" to overwrite the current version with this newer one, or choose "Save As" to keep a separate copy.
Locate Unsaved AutoRecover Files Manually
If the file was saved locally and AutoRecover was active, the newer temporary file might still exist in your system's AppData folder.
Reopen the Document Recovery Pane
Sometimes, restarting the application will prompt the Document Recovery pane to appear again if the unsaved temporary files have not been permanently discarded.
Use WPS Office for Reliable Auto-Backup and File Recovery
Avoid losing your important spreadsheet data. WPS Office offers robust built-in cloud backup, intelligent local auto-recovery, and full compatibility with Microsoft Excel formats, ensuring your work is always safe.
Frequently Asked Questions
Can I recover an Excel file if I accidentally clicked 'Don't Save'?
Yes, if AutoRecover was enabled. Open Excel, go to File > Info > Manage Workbook, and click 'Recover Unsaved Workbooks'. Look for your file in the folder that opens.
Where are AutoRecover files stored in Windows?
By default, Excel AutoRecover files are stored at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. You can verify or change this path in File > Options > Save.
Why is my Excel Version History grayed out or missing?
Version History is only available for files saved to OneDrive or SharePoint. If you are saving the file locally on your hard drive, the Version History feature will not be active.
Does AutoSave replace the need to save manually?
While AutoSave automatically saves changes to the cloud every few seconds, it is still a best practice to manually save milestone versions of your file or use Save As to create separate backup copies before making major structural changes.
