If you accidentally closed Excel without saving, first reopen the program and check the Document Recovery pane; if it does not appear, use File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery is possible only if Excel or a cloud service kept a copy, so open any recovered version and immediately save it under a clear name.
First identify what was lost
The best recovery route depends on whether this was a brand-new workbook, changes to a workbook you had already saved, or a file that disappeared after Excel or the computer crashed. It also matters whether the file was stored on your computer or in OneDrive or SharePoint. Before trying anything, write down the workbook name, its likely folder, and roughly when you last edited it. That can help you distinguish the right copy from an older or similarly named file.
If Excel is still open and the workbook is visible, do not close it. Try saving it first with Ctrl+S on Windows, or Command+S on Mac. If the Save As window appears, choose a location you can find again and use a new filename if you are unsure whether you are overwriting the right copy. If Excel has already closed, avoid cleanup utilities or manually deleting temporary files until you have checked the recovery options.
- New workbook never saved: look for an unsaved recovery copy.
- Previously saved workbook closed without saving: check AutoRecover and, for a cloud-stored file, version history.
- Excel crashed or the computer shut down: reopen Excel and inspect Document Recovery before opening other files.
Recover a new, unsaved workbook in Windows
In Excel for Microsoft 365 on Windows, open Excel and look for a Document Recovery pane at the left. If Excel offers one or more recovered files, open the most recent plausible entry. Check the contents and modified time, then use Save As to create a normal workbook file. A recovered item is not necessarily the latest complete version, so compare it with what you remember before relying on it.
If no recovery pane appears, try the built-in unsaved-workbook list:
- Open Excel and select File > Info.
- Select Manage Workbook, then Recover Unsaved Workbooks. Depending on the Excel layout, you may also find Recover Unsaved Workbooks through File > Open > Recent.
- In the dialog, look for a file with a relevant name or recent date. Select it and choose Open.
- If the workbook contains the missing work, use Save As to save a regular copy in a known folder.
This list is not a complete archive of every workbook you ever opened. Excel can only show a recovery copy if one exists and has not been removed. If the list is empty, or the file is absent, that does not prove the workbook was never on the computer; it means this particular recovery route has no available copy.
Get back changes to a workbook you had saved before
If you edited an existing workbook and chose Don’t Save when closing, look for an AutoRecover copy through the same Recover Unsaved Workbooks route. A copy may contain some of the changes, but AutoRecover is not a guaranteed record of every edit. The original saved workbook may still be intact, while the unsaved changes are not recoverable.
For a workbook stored in OneDrive or SharePoint, check its version history. In the desktop app, open the workbook and look under File > Info > Version History. You can also find version history from the file in OneDrive or SharePoint, though the exact web controls can vary. Open a prior version to inspect it before restoring anything. If you need content from an earlier copy but want to preserve the current one, save a separate copy or copy the needed sheets or cells rather than replacing the current file immediately.
Version history helps only when the file was saved in a location and service that maintains versions and the relevant version is still available. A local workbook in a folder that is not backed up or synchronized may have no version history to consult. Do not confuse an old version with an unsaved recovery copy: version history records saved states, while AutoRecover may hold a temporary recovery state.
What AutoRecover and AutoSave actually do
AutoRecover periodically stores recovery information so Excel may be able to reopen work after an unexpected shutdown. It is a safety net, not the same as saving the workbook. The recovery interval and whether recovery information is kept can be configured in Excel. On Windows, the relevant controls are under File > Options > Save; look for the option to save AutoRecover information and its interval. A shorter interval can reduce the amount of work at risk in a crash, but it does not guarantee that the newest edits will be present.
AutoSave is different: in Microsoft 365, it can save ongoing edits to supported files stored in OneDrive or SharePoint. It is generally unavailable for an ordinary workbook saved only to a local drive. The AutoSave switch appears in Excel when the file and account support it. If it is off, or the file is not in a supported cloud location, do not assume that changes are being saved automatically. A network interruption or sign-in issue can also affect syncing, so check that the latest edits have finished saving before closing the workbook.
Neither feature means every previous state is permanently retained. AutoRecover files can be temporary, and AutoSave may update the current cloud file rather than preserve every edit as a separate permanent copy. Version history, when available, is a separate way to inspect earlier saved versions.
If Excel crashed or the computer shut down
After an unexpected crash, reopen Excel before doing other recovery work. The Document Recovery pane may show multiple entries, often with a recovered timestamp. Open each plausible candidate and check the data rather than assuming the newest-looking entry is complete. Save a useful recovery as a new file first, for example with a name that identifies it as a recovered copy. Once you have verified it, decide whether it should replace or be merged with the original.
If the pane is missing, use Recover Unsaved Workbooks and then check any cloud version history that applies. A crash can happen between AutoRecover intervals, while a power loss, disk problem, or forced shutdown can prevent a recovery file from being written or retained. Excel may also reopen normally if it cannot find a usable recovery copy. Repeatedly launching and closing the program is unlikely to create a missing recovery file; focus on the available recovery locations and avoid removing files that might still be useful.
Mac and Excel for the web differences
Excel for Mac also has AutoRecovery, and after an unexpected quit it may offer recovered work when Excel next starts. Its settings and menus differ from Windows; in many Microsoft 365 Mac builds, AutoRecover settings are under Excel > Preferences or Excel > Settings > Save. Menu wording can vary with the release. If Excel offers a recovered document, save it under a new name before making further changes. The Windows Recover Unsaved Workbooks path should not be assumed to appear identically on a Mac.
Excel for the web works differently because workbooks are normally stored in OneDrive or SharePoint and edits are saved online as you work when connectivity is available. If a browser tab closes, reopen the workbook from its cloud location and confirm that the edits are present. If content was changed or replaced, check the file’s version history. If the browser was offline or changes had not synchronized, recovery is not guaranteed. A desktop-only unsaved recovery file is not something to expect from the web app.
Why recovery may fail
There are several ordinary reasons a workbook may not appear in a recovery list. AutoRecover might have been disabled, Excel might not have reached its next recovery interval, or the recovery copy might have been deleted after Excel closed normally. The workbook could also have been saved under a different name or folder, or an account or sync issue may mean you are checking the wrong OneDrive or SharePoint location.
Search File Explorer for the workbook’s name or for Excel files in likely folders, including Downloads and Documents, but treat search results as a way to locate saved files, not as a substitute for recovery. Avoid relying on instructions that tell you to rename random temporary files: temporary-file locations and formats can differ, and changing the wrong file can make it harder to identify the useful copy. If the workbook is business-critical and stored on a managed network, ask your IT administrator whether a backup or retention policy applies.
Prevent losing spreadsheet work again
A few habits substantially reduce the risk without requiring a complicated backup setup:
- Save a new workbook as soon as you create it, using Ctrl+Shift+S on Windows to open Save As, or Command+Shift+S on Mac where that shortcut is supported.
- Use Ctrl+S on Windows or Command+S on Mac regularly, especially before closing Excel or making a major change.
- For files suitable for cloud storage, save them to OneDrive or SharePoint and confirm AutoSave is on. Watch for sync or sign-in warnings.
- Review the AutoRecover setting in Excel Options on Windows or Excel Preferences/Settings on Mac. Choose an interval that suits the importance and size of your work.
- Keep separate backup copies for important workbooks. Version history is helpful, but it should not be the only copy of data that would be difficult to recreate.
- Before closing a workbook after a long editing session, check that the title or save indicator shows the file has finished saving.
For example, if you create a workbook to track a month’s invoices, save it in the intended folder before entering the first invoice. If Excel then crashes after you add several rows, a saved starting file plus AutoRecover or cloud version history gives you more options than an entirely unnamed workbook. None of these measures guarantees recovery from every failure, but they make a missing file less likely and make the remaining recovery steps clearer.
Frequently Asked Questions
Can I recover an Excel file if I clicked Don’t Save? Possibly. Check File > Info > Manage Workbook > Recover Unsaved Workbooks and, for a OneDrive or SharePoint file, inspect version history. If Excel kept no recovery copy and no earlier cloud version contains the edits, the unsaved changes may be gone.
Where does Excel store unsaved files? Excel manages temporary recovery data in locations that can depend on the version and settings. The safer first step is the Recover Unsaved Workbooks command or the Document Recovery pane, rather than trying to locate and alter hidden temporary files manually.
Does AutoSave recover a file I never saved? Not usually for a brand-new workbook that has not been given a supported OneDrive or SharePoint location. AutoSave applies to supported cloud-stored files; for a new unsaved workbook, check AutoRecover and save the file as soon as possible.
Can I recover an Excel file after restarting my computer? Sometimes. Start Excel and check the Document Recovery pane, then try Recover Unsaved Workbooks. Success depends on whether recovery data was written and retained before the restart.
How do I recover an older version of an Excel workbook? For a file in OneDrive or SharePoint, open its Version History from Excel’s File > Info area or the cloud storage interface. Inspect the version first, then restore it or save a separate copy so you do not overwrite the current workbook by mistake.
Related
- Excel Import CSV Without a Table: Keep a Plain Range
- Excel Import CSV and TXT Files: How It Works
- Excel Import CSV Into Template: Steps and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create Rules in Microsoft OutlookCreate an Outlook rule by choosing a condition, such as who sent a message or words in its…
- How to Add a Custom Watermark in Microsoft Word DocumentsTo add a custom watermark in Microsoft Word for Microsoft 365 on Windows, open the document and select…
- Excel Group Rows: How to Collapse and Expand DetailsIn Excel for Microsoft 365 on Windows, select the row headers you want to group, then choose Data…
- Excel Cell Gradient Fill: What Works and What Doesn’tExcel for Microsoft 365 on Windows does not offer a native gradient fill for an individual worksheet cell…
- How to Change Slide Size in PowerPointTo change a presentation’s size in PowerPoint for Microsoft 365 on Windows, go to Design > Slide Size,…
- How to Insert a Dropdown List in Excel Step by StepTo insert a dropdown list in Excel for Microsoft 365 on Windows, select the cell or cells, go…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.