To open an unsaved Excel workbook in Microsoft 365 for Windows, select File > Open > Recent, then choose Recover Unsaved Workbooks near the bottom of the page. Open a listed file and immediately use File > Save As to save it somewhere you can find. Recovery works only if Excel created a recovery copy; it cannot guarantee that every unsaved change can be restored.
What “unsaved Excel file” can mean
People use “unsaved Excel file” for several different situations, and the best recovery route depends on which one happened. You might have created a new workbook and never saved it, edited a workbook that already had a filename but did not save the latest changes, or closed Excel after a crash and now want to retrieve a recovery copy. These are not quite the same problem.
A new workbook may have existed only in Excel’s memory until you saved it for the first time. An existing workbook has a saved version on disk or in cloud storage, but changes made after the last save may be missing from that version. Excel’s AutoRecover feature can preserve temporary copies or recent edits in either situation, depending on the settings and timing. It is a recovery aid, not a permanent substitute for saving.
If you mean that you want to open a file without saving changes to it, open it normally and choose not to save when prompted to close. If you mean you want to retrieve work that was never saved, use the recovery steps below.
Recover a workbook in Excel for Windows
Start with Excel’s built-in recovery list. The exact list varies according to what Excel managed to save, so you may see one copy, several copies, or no available workbook.
- Open Excel. If the workbook is already open, first check whether a Document Recovery pane appears at the left. After an unexpected shutdown, Excel may offer one or more recovered versions there.
- If there is no recovery pane, select File > Open > Recent.
- Select Recover Unsaved Workbooks near the bottom of the Recent page. If the command is not visible, check that you are in Excel’s Recent page rather than a file picker or another Office app.
- In the list, select the workbook that looks like the one you need, then select Open. Review its contents and check the sheet names, values, and last visible changes before relying on it.
- Save the recovered copy with File > Save As. Choose a recognizable filename and a location such as Documents or a project folder. Do not assume that opening a recovery copy automatically saves it as a normal workbook.
For example, if a new workbook containing a monthly schedule disappeared when Excel closed unexpectedly, the recovery list might contain a file with a generic name rather than “Monthly Schedule.” Open likely candidates and inspect them before saving the correct one. If Excel shows a recovered version of an existing workbook, save it under the original name only after confirming whether you want to replace the saved version.
Recover unsaved changes to a workbook you already saved
If the workbook had a filename before the problem, first open that saved file and check whether the changes are already there. A crash may have occurred after a save completed, or Excel may have restored the latest version automatically. If the recent changes are missing, look for the Document Recovery pane or use File > Info > Manage Workbook to see whether a recoverable version is offered. Depending on the Excel build and workbook state, the page may show versions or recovery options.
When you find a candidate, compare it with the saved workbook rather than assuming the newest-looking entry is complete. Check the affected worksheet, the most recent rows or edits, and any formulas or charts you changed. You can save a recovered copy with a different name first, which preserves the original while you decide which version to keep.
For a workbook saved on OneDrive or SharePoint, also check its version history. Open the workbook and select its filename or use File > Info to find version-history options, depending on the interface. Version history can help restore an earlier cloud-saved state, but it is different from recovering a never-saved local workbook. It only helps when the file was stored in a supported cloud location and versions are available.
How AutoRecover and AutoSave differ
AutoRecover periodically keeps recovery information so Excel can offer work after an unexpected closure. Its purpose is to help recover unsaved edits; it does not mean every keystroke is safely stored. If Excel closes normally, the temporary recovery data may be removed, and if the application or computer fails before the next recovery interval, the latest changes may not be included.
AutoSave is a separate feature for supported files stored on OneDrive or SharePoint. When it is available and switched on, changes to a cloud workbook are saved continuously. A new local workbook that has never been saved to a cloud location generally cannot rely on AutoSave as though it already had a permanent file. Save the workbook to the intended location first, then check the AutoSave switch in Excel.
To review AutoRecover settings in Excel for Windows, select File > Options > Save. There you can inspect the setting for saving AutoRecover information and the displayed AutoRecover file location. A shorter interval can reduce the amount of work at risk, but recovery still depends on Excel being able to write the recovery data. The setting does not replace Ctrl+S, which saves the workbook itself.
Find recovery files and check common problems
If the recovery command does not show the workbook, check Excel’s configured recovery location. In Windows, open File > Options > Save and look at the AutoRecover file location. You can copy that location into File Explorer to inspect it. Avoid deleting or renaming files there while trying to recover work; first make a separate copy of any candidate file, then try opening the copy in Excel.
A blank list does not necessarily mean you missed a hidden workbook. Excel may not have created a recovery copy, the recovery copy may have been removed after a normal close, or the workbook may have been stored somewhere else. Also check the folder where you normally save files, the Windows Recycle Bin if you deleted a saved workbook, and OneDrive or SharePoint if the workbook was cloud-based. Those locations address different problems: deleting a saved file is not the same as losing unsaved edits.
- The workbook opens but seems old: compare it with the last saved copy and check any other entries in Document Recovery. A recovery file may predate your final edits.
- The file will not open: make a copy before trying repairs, confirm the file extension is appropriate, and use Excel’s File > Open > Browse dialog. Select the file, use the arrow beside Open, and choose Open and Repair if that option is offered.
- You cannot find the command: check File > Open > Recent, and verify that you are using the desktop Excel app. Excel for the web has different recovery and file-history options.
Do not download a supposed recovery utility or change file extensions at random just because the recovery list is empty. Such steps cannot recreate data that was never written to a recoverable file, and unfamiliar tools can expose sensitive workbook contents or make a damaged file harder to assess.
Excel for Mac and Excel for the web
These steps primarily describe Microsoft 365 Excel for Windows. Excel for Mac has its own recovery behavior and settings, and its menus and recovery-file locations differ. After an unexpected quit, reopen Excel and look for any recovery prompt or recovered workbook it presents. If the workbook was stored on OneDrive or SharePoint, check its cloud version history as well. Do not assume that the Windows AutoRecover folder path or Windows menu route applies to a Mac.
Excel for the web generally saves changes to a workbook in OneDrive or SharePoint as you work, provided the workbook is open and connected to the service. If you closed a browser tab, reopen the cloud workbook and check the latest saved content. If you were working offline, using a disconnected browser session, or had never saved a new workbook to a cloud location, the online version may not include those edits. Check the service’s version history where available, and use the desktop app’s recovery features only for work that was actually opened or handled there.
Prevent losing unsaved work next time
The most reliable habit is to save a new workbook as soon as you create it. Press Ctrl+S on Windows; on Mac, use Command+S. For a new workbook, Excel then asks for a filename and location. Once the file has a regular saved copy, save periodically as you make important changes. You can also select the Save icon in the title bar.
For work that changes frequently, save the file in OneDrive or SharePoint and confirm that AutoSave is on. Keep a clear filename and folder structure so a recovered copy does not get confused with an older version. Before making a substantial edit to a critical workbook, consider saving a separate copy or using version history. This is especially useful when several people collaborate, because a cloud file’s history can help distinguish saved versions.
- Check File > Options > Save and confirm that AutoRecover information is being saved at a suitable interval.
- Do not close Excel while it is still saving, syncing, or showing an upload problem.
- For important work, keep a second copy in a trusted location rather than relying on a single temporary recovery file.
- After a crash, save the recovered workbook under a new name until you have confirmed it contains the version you need.
Frequently Asked Questions
Can I open an Excel file that I never saved?
Possibly. In Excel for Windows, try File > Open > Recent > Recover Unsaved Workbooks. You can open a workbook only if Excel has a recovery copy available; a workbook that was never saved and has no recovery copy cannot be reconstructed from Excel.
Where is Recover Unsaved Workbooks in Excel?
In Microsoft 365 Excel for Windows, look near the bottom of File > Open > Recent. You can also review recovery settings and the AutoRecover file location under File > Options > Save.
Can I recover an Excel file after clicking Don’t Save?
It may be possible if Excel retained a recovery copy, so check the unsaved-workbook list promptly. However, choosing Don’t Save can discard temporary recovery information. If no recovery copy or cloud version exists, Excel may not be able to restore the discarded changes.
Does AutoSave recover a workbook I never saved?
Usually, you must first save a workbook to a supported OneDrive or SharePoint location for AutoSave to keep updating that cloud file. AutoRecover is the feature to check for a workbook or edits that were not saved normally.
Can I recover unsaved Excel work on a Mac?
Sometimes, depending on whether Excel created recovery information and how the app closed. Reopen Excel and check for a recovery prompt; also check cloud version history if the workbook was stored on OneDrive or SharePoint. Windows recovery paths and menus may not match the Mac interface.
Why is my recovered workbook missing the last few changes?
AutoRecover saves information periodically rather than guaranteeing a copy of every keystroke. The recovery copy may therefore be older than your last edits. Save recovered work immediately, then compare it with other available recovery or cloud versions.
Related
- How to Merge Two Tables in Excel Using Power Query
- Median vs Average in Excel: Which Should You Use?
- Merge Columns in Excel with Power Query
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 Check Duplicate Entries in Excel with Easy MethodsTo check for duplicate entries in Excel, select the cells you want to check and choose Home >…
- How to Add Headers in Excel on SharePoint and Format ThemTo add column headers to an Excel workbook stored in SharePoint, open the workbook for editing, enter a…
- Excel: Shade the Area Under a CurveTo shade the area under a curve in Excel, put your x-values in one column and y-values in…
- Outlook: How to Add an Email Folder to a Shared MailboxYes. In Outlook, open the shared mailbox in the folder pane, right-click its name or the folder where…
- Data Validation Excel Shortcut and How to Use ItIn Excel for Microsoft 365 on Windows, press Alt, then A, V, and V—one key at a time—to…
- Unable to Add Page Numbers in Word? Fixes That WorkIf you’re unable to add page numbers in Word, click Insert > Page Number on Windows, choose a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.