Recover a Lost Excel Workbook or Unsaved Data
Question details
Recover a lost Excel workbook or unsaved data after opening or saving another file with the same name.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user needs to find an earlier workbook or recover changes that were not saved.
- Observed behavior
- The expected workbook or its latest data is missing after another file with the same name was opened or saved.
Check the workbook name and its original folder, and avoid saving another file over it while you search. If the workbook was stored in OneDrive or SharePoint, sign in to the account that has access to it.
Recover an unsaved workbook in Excel
Use Excel's recovery options when a workbook was closed without saving or Excel stopped unexpectedly.
In Excel, select File > Info > Manage Workbook > Recover Unsaved Workbooks.
Open a candidate file from the list and check its contents for the missing data.
Select Save As and give the recovered workbook a new filename in a known folder.
If Excel displays a Document Recovery pane after restarting, open the listed versions and save the one you need under a new name.

Restore an earlier version from OneDrive or SharePoint
Use version history if the workbook was stored in OneDrive or SharePoint and a previous version is available.
Search for the workbook or a deleted copy
Check the original folder, deleted files, and Excel's AutoRecover location when the workbook is not visible.
Work with Recovered Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet to review and continue editing recovered files; Excel recovery and cloud version history remain separate Microsoft features.

Frequently Asked Questions
Where can I find unsaved Excel workbooks?
In Excel, go to File > Info > Manage Workbook > Recover Unsaved Workbooks. Open a listed file and use Save As to keep it under a new name.
Can I recover a workbook overwritten by another file?
If the file was stored in OneDrive or SharePoint, open its Version history and check for an earlier version. Recovery depends on whether a suitable version was retained.
Where does Excel store AutoRecover files?
In Excel for Windows, go to File > Options > Save and check the AutoRecover file location. Open that folder to look for relevant recovery files.
Will the Recycle Bin restore an overwritten workbook?
The Recycle Bin may restore a deleted file, but it generally does not contain earlier versions of an overwritten file. Check cloud version history if the workbook was stored in OneDrive or SharePoint.




