How To Recover An Unsaved Excel Workbook (2026)

If Excel closed or crashed before you saved, the workbook may still be recoverable.

Excel keeps background copies while you work, and the steps below show where to find them.

Everything here comes from Microsoft’s support pages, and the first thing to do is stop and avoid saving over anything.

Quick answer: where to look first

Your situationWhere to look
Excel crashed or lost powerReopen Excel and check the Document Recovery pane
You never saved the workbook at allFile > Info > Manage Workbook > Recover Unsaved Workbooks
You saved earlier, then closed without saving the latest changesFile > Info, then the version marked “(when I closed without saving)”
The file is on OneDrive or SharePointVersion history, from the file title or by right-clicking the file
You use Excel on a MacReopen Excel, or browse the hidden AutoRecovery folder with Go To Folder

Before you start: do not save over it

Do not type into a new workbook and save it under the old name while you look for the lost one.

Microsoft notes on the Mac that manually saving a file deletes its previous AutoRecover files.

The same page says that choosing Don’t Save when closing a file deletes that file’s AutoRecover copy.

So open the recovery options first and decide what to keep before you close anything.

Check the Document Recovery pane

After Excel closes unexpectedly, the Document Recovery pane opens the next time you start the app.

It lists files recovered from your last manual save, your last AutoSave (OneDrive or SharePoint, Microsoft 365 subscribers) or your last AutoRecover.

  1. Compare the date and time shown under each file name.
  2. Click a file to open and review it, or click the arrow beside it to choose Open or View, Save As, Delete, Close or Show Repairs.
  3. Use Save As on the version you want to keep.
  4. Select Close, then choose to keep the files to view later if you are unsure.

If you have several versions of one file, the most recent time usually holds the latest changes.

If you close the pane before reviewing every file, Excel offers to show them again the next time you open it.

Recover a workbook you never saved

  1. Open Excel and start from any workbook.
  2. Select File > Info.
  3. Select Manage Workbook, then Recover Unsaved Workbooks.
  4. Select the file you want, then select Open.
  5. In the bar at the top of the file, select Save As to keep it.

Microsoft words this step as Manage Document in one place and Manage Workbook in another, and both lead to the same recovery option.

Save the recovered file with a new name and location straight away.

Recover the last version before you closed without saving

This applies when you saved the file earlier and then closed it without saving the latest edits.

  1. Open the file.
  2. Select File > Info.
  3. Under Manage Workbook, select the version labeled “(when I closed without saving)”.
  4. In the bar at the top, select Restore.

Microsoft warns that Restore overwrites previously saved versions.

If you want to keep both, use Save As to store a copy before restoring.

These steps only work when AutoRecover was turned on while you were editing.

Turn on AutoRecover so it does not happen again

  1. Select File > Options > Save.
  2. Tick Save AutoRecover information every x minutes and set the minutes.
  3. Tick Keep the last autorecovered version if I close without saving.
IntervalWhat Microsoft says
5 or 10 minutesSuggested so you never lose more than that much work
15 minutesA recovered file could be missing the last 14 minutes
20 minutesMay make Office slightly faster, with more work at risk

AutoRecover is a safety net, and Microsoft says it does not replace saving.

Press Ctrl+S often if AutoSave is off or the file is not on OneDrive or SharePoint.

If the file is on OneDrive or SharePoint

AutoSave saves changes continuously for files stored in OneDrive or SharePoint, so you rarely lose work.

Version history only works for files stored there.

  1. Open the file, click the file title at the top, and select Version history.
  2. Select a version to open it in a separate window.
  3. Select Restore to bring that version back.

In File Explorer you can also right-click the file and select Version history.

Microsoft says personal accounts can retrieve the last 25 versions, while work or school accounts depend on the library settings.

Restoring a version replaces the current one, so updates made after it are lost.

If OneDrive itself is misbehaving, see how to fix OneDrive stuck on processing changes.

The Unsaved Changes pane

Excel for Microsoft 365 on Windows has an Unsaved Changes pane for edits that have not reached the cloud.

It shows changes to cell values and formulas, including moving, sorting, inserting and deleting cells.

It does not show charts, shapes, objects, PivotTables, formatting, hidden cells or filtering.

The pane lists only your own changes, and it may be empty if you kept editing without saving a copy or discarding them.

Recover an unsaved workbook on a Mac

On Excel for Microsoft 365 for Mac, AutoRecover saves a background copy every 10 minutes by default.

After a crash or power loss, Excel usually finds the AutoRecover file and opens it the next time you launch the app.

  1. Open Finder and choose Go > Go To Folder, or press Shift + Command + G.
  2. Enter /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft, replacing <username> with yours.

The folder is hidden, which is why Go To Folder is needed, and Microsoft’s path ends at Microsoft, so look inside that folder for the files.

Mac behaviorDetail
Excel AutoRecover settingYou can only turn it on or off, and Excel sets the interval
Excel AutoRecover locationCannot be changed in Excel
Manual saveDeletes the previous AutoRecover files
Don’t Save on closeDeletes that file’s AutoRecover file

Other Office apps

The same recovery logic applies to other Office apps, and the Word steps are in how to recover an unsaved Word document.

If Excel keeps crashing, try repairing Microsoft 365 apps on Windows 11.

If Excel says the workbook is locked, see how to fix Excel file locked for editing.

Sources

Leave a Reply

Your email address will not be published. Required fields are marked *