File Corruption & Recovery

Recover a Lost Excel Workbook or Unsaved Data

Phi Hung VoPhi Hung Vo Nov 18, 2026 870 views

Question details

Recover a lost Excel workbook or unsaved data after opening or saving another file with the same name.

How to Recover a Lost Excel Workbook or Unsaved Data
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.
Before you start

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.

Solution 1Recommended

Recover an unsaved workbook in Excel

Use Excel's recovery options when a workbook was closed without saving or Excel stopped unexpectedly.

1
Open unsaved workbooks

In Excel, select File > Info > Manage Workbook > Recover Unsaved Workbooks.

2
Inspect available files

Open a candidate file from the list and check its contents for the missing data.

3
Save the recovered file

Select Save As and give the recovered workbook a new filename in a known folder.

4
Check AutoRecover

If Excel displays a Document Recovery pane after restarting, open the listed versions and save the one you need under a new name.

Recover an unsaved workbook in Excel
Recovery files may not be available: Excel can recover only files or changes for which it retained recovery data. Unsaved recovery does not guarantee restoration of an overwritten workbook.
Free Microsoft Office alternative

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.

Open and review recovered workbook data in WPS SpreadsheetCompatible with Microsoft Excel formats, including XLS and XLSXFamiliar spreadsheet interface for an easier transitionLightweight Office suite with free tools
microsoft office alternative - wps office

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.