Recover an unsaved Excel file
Start Excel again and check the Document Recovery pane. If nothing shows, go to File, Info, Manage Workbook, Recover Unsaved Workbooks (Microsoft also labels it Manage Document), open the workbook and click Save As. For a file saved before, the entry marked when I closed without saving brings back the last AutoRecover copy. All of this needs AutoRecover to have been on.
Checked November 10, 2026 against the manufacturer's own pages.
The short version
What to install and where it comes from. Every link goes to the manufacturer or Microsoft, never to a copy.
Official files only, nothing bundled
Step by step
Restart Excel on its own
Open Excel without double-clicking any workbook. When it closed unexpectedly, the Document Recovery list on the left shows the versions it kept, each with a time. Open the latest one first.
Save each recovered workbook
Use the arrow next to the entry and choose Save As, with a new file name, before you edit anything. Keep the old copy until you have checked the formulas and sheets.
Open Recover Unsaved Workbooks
For a workbook that never had a name, open a blank sheet, then File, Info, Manage Workbook, Recover Unsaved Workbooks. Pick the file, choose Open and use Save As in the yellow bar.
Roll back a saved workbook
Open the saved file, go to File, Info and under Manage Workbook choose the item marked when I closed without saving. Restore puts that version back over the saved one.
Use Version History for OneDrive files
If the workbook lives in OneDrive or SharePoint, File, Info, Version History lists earlier saves. Open one to preview it, then restore or copy the cells you need.
Search the drive last
Search This PC for *.xlsx sorted by date in case the file was saved elsewhere. If that fails, a recovery program that reads the disk directly is the final attempt, saving finds to another drive.
If the free methods found nothing
Deleted files usually stay on the drive until new data overwrites them. A recovery program reads the drive directly, lists what can still be saved and lets you preview it before restoring. Save recovered files to a different drive.
Find and preview your deleted files
Scans hard drives, USB sticks and memory cards, including quick-formatted ones, and shows what can be recovered.
Auslogics File Recovery 12 · Free scan and preview · NTFS, FAT, exFAT · Windows 11, 10, 8, 7
How Excel keeps workbooks you never saved
Excel runs a timer in the background. Each time it fires, the workbook you are editing is copied into an AutoRecover store, even if you never gave it a name. A crash, a forced update restart or a dead battery leaves those copies behind, and Document Recovery uses them on the next launch. Recover Unsaved Workbooks lists the ones for files that had no name yet. The newest copy is only as fresh as the last timer, so a few minutes of work can still be missing.
Things that make the workbook unrecoverable
If AutoRecover was switched off under File, Options, Save, Excel kept no copies. If you closed with Do not save and the box Keep the last autorecovered version if I close without saving was cleared, the copy is discarded. Picking No, remove the files when closing the recovery pane does the same. A workbook that crashed before the first timer ran has no copy at all. In those cases, no menu or scan inside Excel can help, and the honest answer is that the data was never stored.
Set Excel up so it cannot happen twice
In File, Options, Save, tick both AutoRecover boxes and choose a short interval; Microsoft suggests 5 or 10 minutes. Save workbooks to OneDrive and turn on AutoSave at the top left of the window, which also gives you Version History. For shared sheets, Review, Show Changes lists who changed which cells. And name a new workbook in its first minute, so it never sits as Book1 waiting for a crash.
Questions
Where does Excel keep unsaved workbooks?
In a hidden AutoRecover store that Recover Unsaved Workbooks opens for you. Using that menu is safer than digging through system folders.
Why is Recover Unsaved Workbooks empty?
Either AutoRecover was off, the workbook was closed before the first timer ran, or the copy was already removed. In that case Excel has nothing to offer.
Does AutoSave replace AutoRecover?
For files on OneDrive or SharePoint, AutoSave writes changes as you go, so AutoRecover is rarely needed. Local workbooks still depend on AutoRecover.
Can I get back a sheet I deleted and then saved?
Not with Undo after saving. Use Version History for cloud files, or Restore previous versions in File Explorer if File History was running.