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 situation | Where to look |
|---|---|
| Excel crashed or lost power | Reopen Excel and check the Document Recovery pane |
| You never saved the workbook at all | File > Info > Manage Workbook > Recover Unsaved Workbooks |
| You saved earlier, then closed without saving the latest changes | File > Info, then the version marked “(when I closed without saving)” |
| The file is on OneDrive or SharePoint | Version history, from the file title or by right-clicking the file |
| You use Excel on a Mac | Reopen 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.
- Compare the date and time shown under each file name.
- 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.
- Use Save As on the version you want to keep.
- 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
- Open Excel and start from any workbook.
- Select File > Info.
- Select Manage Workbook, then Recover Unsaved Workbooks.
- Select the file you want, then select Open.
- 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.
- Open the file.
- Select File > Info.
- Under Manage Workbook, select the version labeled “(when I closed without saving)”.
- 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
- Select File > Options > Save.
- Tick Save AutoRecover information every x minutes and set the minutes.
- Tick Keep the last autorecovered version if I close without saving.
| Interval | What Microsoft says |
|---|---|
| 5 or 10 minutes | Suggested so you never lose more than that much work |
| 15 minutes | A recovered file could be missing the last 14 minutes |
| 20 minutes | May 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.
- Open the file, click the file title at the top, and select Version history.
- Select a version to open it in a separate window.
- 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.
- Open Finder and choose Go > Go To Folder, or press Shift + Command + G.
- 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 behavior | Detail |
|---|---|
| Excel AutoRecover setting | You can only turn it on or off, and Excel sets the interval |
| Excel AutoRecover location | Cannot be changed in Excel |
| Manual save | Deletes the previous AutoRecover files |
| Don’t Save on close | Deletes 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
- Recover an earlier version of an Office file (Microsoft Support)
- Help protect your files in case of a crash (Microsoft Support)
- Recover your Microsoft 365 files (Microsoft Support)
- Recover files in Office for Mac (Microsoft Support)
- View previous versions of Office files (Microsoft Support)
- Get help with unsaved changes in Excel (Microsoft Support)