Recover an Unsaved Excel Workbook Using AutoRecover or Version History
Question details
The user needs to recover a day's work in an Excel workbook after reverting to a previous state and closing without saving.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The workbook was reverted to a previous state and then closed without saving.
- Observed behavior
- The day's changes were lost, and the temporary-file folders checked afterward were empty.
Identify whether the workbook was stored locally, in OneDrive, or in SharePoint. If you find a recovery candidate, open it and use Save As to preserve a separate copy.
Check Excel AutoRecover and unsaved workbook locations
Look for an AutoRecover copy or an unsaved workbook that Excel retained.
Recovery files are more likely to remain after a crash or unexpected shutdown than after a normal close. A locally stored workbook closed without saving may not have a recoverable copy.
Open Excel and look for a Document Recovery pane. If a recovered workbook appears, open it and choose File > Save As to save a separate copy.
In Excel, select File > Info > Manage Workbook > Recover Unsaved Workbooks. Open any relevant candidate and use Save As to keep it.
In Excel for Windows, go to File > Options > Save and note the AutoRecover file location. Open that folder in File Explorer and look for a relevant recovery file.
On Windows, paste %localappdata%\Microsoft\Office\UnsavedFiles into the File Explorer address bar. Open any relevant file in Excel and save it under a new name.

Restore a saved Excel version from OneDrive or SharePoint
Use Version History if the workbook was stored in OneDrive or SharePoint and an earlier saved version contains the missing work.
Work with Excel files in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files, although it cannot recover Excel changes that were never saved.

Frequently Asked Questions
Can Excel recover changes after I close a workbook without saving?
Sometimes, but recovery is not guaranteed. Check the Document Recovery pane and File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery files are more likely to remain after a crash than after a normal close.
Where does Excel store AutoRecover files on Windows?
In Excel, go to File > Options > Save and check the AutoRecover file location. You can also check %localappdata%\Microsoft\Office\UnsavedFiles in File Explorer for unsaved workbook candidates.
Can Version History recover work that was never saved?
Version History only provides available saved versions. Open the workbook from OneDrive or SharePoint, select Version History, and review the versions to see whether one contains the work.
What if the temporary and recovery folders are empty?
Check Version History if the workbook was stored in OneDrive or SharePoint. If no recovery file or saved version contains the changes, the discarded work may not be recoverable.




