Updated 2026-05-22 · Document Recovery

How to Recover an Unsaved Excel File

If Excel closed, crashed, or your workbook disappeared before you saved it, check Excel's built-in recovery options before searching your folders manually. Excel can recover some unsaved workbooks, earlier versions, and corrupted files, but the right path depends on whether the workbook had ever been saved.

Fastest Recovery Path

  1. Reopen Excel and check for Document Recovery.
  2. Go to File > Info > Manage Workbook > Recover Unsaved Workbooks.
  3. Open the most likely workbook.
  4. Save it immediately with Save As.
  5. If the workbook was saved in OneDrive or SharePoint, check Version History.

Recover Unsaved Workbooks

For a workbook that was never saved:

  1. Open Excel.
  2. Select File.
  3. Select Info.
  4. Select Manage Workbook.
  5. Select Recover Unsaved Workbooks.
  6. Open the workbook.
  7. Save it immediately.

If you see more than one recovery file, open them one at a time and compare the contents before deciding which one to keep.

Use Version History for Cloud Files

If the file was stored in OneDrive or SharePoint, AutoSave may have stored versions while you worked. Open the file and check version history. Preview the version before restoring it, because restoring an older version can replace the current workbook.

Check Unsaved Changes in Microsoft 365

In Excel for Windows on Microsoft 365, Excel may show an Unsaved Changes pane for recent edits that did not save to the cloud. This is especially relevant when changes were waiting to upload.

The pane may not include every type of change. Microsoft notes that some changes, such as formatting, charts, filtering, hidden cells, and PivotTable operations, may not appear there.

If the Workbook Is Corrupted

If the workbook exists but will not open, use Excel's repair option:

  1. Open Excel.
  2. Go to File > Open.
  3. Browse to the workbook.
  4. Select the file.
  5. Use the arrow next to Open and choose Open and Repair.

If repair fails, try extracting data or reverting to a previous version if you have one.

Prevention Settings

Make sure AutoRecover is enabled and that Excel keeps the last autosaved version if you close without saving. For important workbooks, saving to OneDrive or SharePoint can improve recovery options, but it also means AutoSave may preserve unwanted edits unless you use a copy.

Sources

Ad placement reserved