Find Excel Spreadsheet Not Saved? Recovery Steps That Work

If you closed an Excel workbook without saving, open Excel and select File > Info > Manage Workbook > Recover Unsaved Workbooks, then open the most recent candidate and save it with a new name. This can recover a temporary AutoRecover copy, but it cannot guarantee recovery of every unsaved change; if the workbook was stored in OneDrive or SharePoint, check its version history as well.

Start with Excel’s unsaved-workbook recovery

In Excel for Microsoft 365 on Windows, the built-in recovery list is the best first place to look when you created a workbook and never saved it, or when you closed a workbook and chose not to save. Follow these steps:

Open Excel. If a recovery pane appears on the left, review the listed files before opening anything else.
Select File > Info.
Choose Manage Workbook, then Recover Unsaved Workbooks. The command may not appear if Excel has no recoverable file available.
In the dialog, select a promising file and choose Open. Check the contents and the modification time rather than assuming the newest-looking name is the right workbook.
If it contains the work you need, immediately choose File > Save As, select a normal folder, and save it as an Excel workbook.

Recovered files can have generic names, and the copy may be older than your last edit. Save the recovered version under a new name first; that preserves the recovered copy while you compare it with any original file. If the command opens an empty folder or there are no useful candidates, continue with the checks below.

Check what happened before searching

The right recovery route depends on whether the workbook was never saved, whether a saved workbook lost recent edits, or whether the file was deleted or moved. These are different problems. A first-time workbook has no normal location to search, while a previously saved workbook may still exist in its original folder, a cloud drive, or the Windows Recycle Bin.

Never saved: Try Recover Unsaved Workbooks and the AutoRecover location. Excel needs to have created a temporary recovery copy for this method to help.
Saved before, but recent changes disappeared: Open the original file and check its recovered version, cloud version history, or backup copies.
File missing or deleted: Search File Explorer, check the Recycle Bin, and look in OneDrive or SharePoint if the file was stored there.
Excel closed unexpectedly: Reopen Excel and look for the Document Recovery pane, which may list versions from the interrupted session.

Also check Excel’s Recent list through File > Open > Recent. This list helps locate a workbook that was saved but is now hard to find; it does not itself restore a workbook that was never saved. If an entry is available, use its menu to open the file location when that option is shown.

How AutoRecover and AutoSave differ

AutoRecover periodically stores recovery information so Excel may restore work after a crash or unexpected shutdown. In Excel for Windows, the interval and related options are under File > Options > Save. The setting named Save AutoRecover information every controls how often Excel creates recovery information. The option Keep the last autorecovered version if I close without saving can help when you intentionally or accidentally close without saving.

AutoRecover is not the same as a normal save. A recovery copy may be several minutes behind your latest edit, and a computer shutdown, application failure, or cleanup process can prevent a usable copy from being available. It is a safety net, not a substitute for saving with Ctrl+S.

AutoSave is different again: it continuously saves changes for supported files stored in OneDrive or SharePoint. It generally does not turn an entirely new, never-saved local workbook into a file with a known location. Save a new workbook to a cloud location first if you want cloud AutoSave and version history to protect later edits. On Windows, Ctrl+S saves; on Mac, use Command+S.

Locate the AutoRecover folder on Windows

If the recovery command does not show the file, check the folder Excel is configured to use. In Excel for Windows, open File > Options > Save and look for the AutoRecover file location. Select and copy that location, then paste it into File Explorer’s address bar. The exact folder can differ between installations, so use the location shown in your own Excel settings instead of relying on a generic path found online.

Look for files with recent dates and open likely candidates from Excel. If you find a workbook that opens, use Save As to make a regular copy in a folder you control. Avoid renaming random temporary files or changing their extensions: a temporary file may not be a complete workbook, and changing its name does not repair missing data.

For a previously saved file, search File Explorer for part of its name or for Excel workbook extensions such as .xlsx and .xlsm. Check likely folders such as Documents, Desktop, Downloads, and any work or school folders. If the file was deleted, open the Recycle Bin, select it, and choose Restore. Restoring puts it back in its former location when that location is available.

Recover a cloud workbook or use version history

If the workbook was saved in OneDrive or SharePoint, find it in the cloud location or in Excel’s Recent list. OneDrive on the web lets you browse files and check its recycle bin; SharePoint files may also be available through the site’s recycle bin, subject to the organization’s retention and access settings. A deleted file may be recoverable there even when it is no longer in the computer’s Recycle Bin.

For changes that were saved and later overwritten, look for Version history from the file’s OneDrive or SharePoint menu, or from the workbook’s File information where available. Review the dates and open an earlier version before restoring it. If you restore a version, be aware that it may replace the current cloud version; when possible, make a separate copy first or compare versions so you do not discard newer edits someone else made.

Excel for the web saves supported workbooks to OneDrive or SharePoint as you work, so there is no Windows-style local Recover Unsaved Workbooks command for a workbook that never reached cloud storage. Check the cloud file list, browser session, and version history. If changes were made offline or the browser closed before syncing, recovery depends on whether the changes were stored and synchronized; browser cache is not a dependable backup to search manually.

What Mac users should check

Excel for Mac also has AutoRecovery, but its menus and file locations differ from Windows. After reopening Excel, check whether a recovered workbook appears. If it does, save it immediately using File > Save As. For files already saved in OneDrive or SharePoint, use the cloud service’s file list and version history rather than looking only for a local recovery file.

To inspect AutoRecovery files on a Mac, Microsoft’s Office storage location can vary with the Excel version and installation. Check Excel’s settings and Microsoft’s current support guidance for the relevant AutoRecovery folder rather than assuming a Windows path applies. Finder’s Go to Folder can open a known location if you have verified it. Do not delete unfamiliar recovery files until you have checked whether they contain the missing workbook.

Keyboard shortcuts differ: use Command+O to open and Command+S to save on Mac, compared with Ctrl+O and Ctrl+S on Windows. Excel for the web uses the browser and cloud storage, so its recovery options are different from the desktop Mac application.

Common reasons recovery does not work

A missing workbook in the recovery list does not necessarily mean Excel has hidden a recoverable copy. AutoRecover may have been disabled, the file may have closed before the first recovery interval, or the temporary copy may have been removed. If you selected Don’t Save, Excel normally discards the current unsaved changes; the recovery feature may still retain a copy in some circumstances, but it is not assured.

Other common explanations include checking a different Windows or Microsoft 365 account, searching the wrong OneDrive or SharePoint site, or mistaking an older recovery copy for the latest version. A workbook can also be stored in a folder that is not included in a familiar Documents or Desktop search. Try the exact AutoRecover location and cloud account associated with the session.

Be cautious with third-party recovery tools that promise to restore any unsaved Excel file. They cannot recreate data that was never written to a file or recovery copy, and granting them access to work documents may expose confidential information. Start with Excel, your cloud provider, the Recycle Bin, and backups maintained by your organization.

Prevent the next loss

For a new workbook, save it early with Ctrl+S on Windows or Command+S on Mac, choose a meaningful name, and save it in a folder that is included in your normal backup routine. For work that benefits from cloud protection, save the file in OneDrive or SharePoint and confirm that AutoSave is active. A cloud icon or status indicator can help show whether changes have synchronized, but do not close the application if Excel reports that saving or uploading is still in progress.

In Windows Excel, review File > Options > Save to confirm AutoRecover is enabled and set to an interval that suits your work. Keep in mind that shorter intervals may create recovery copies more often but do not replace deliberate saves. Organizations may also provide managed backups or retention policies; ask an administrator before assuming a deleted work file is permanently gone.

Frequently Asked Questions

Where does Excel store unsaved files?

On Windows, Excel’s AutoRecover file location is displayed under File > Options > Save. The Recover Unsaved Workbooks command is usually easier than browsing manually. The location and behavior differ on Mac, and Excel for the web relies on cloud storage rather than a Windows-style local recovery folder.

Can I recover an Excel file after clicking Don’t Save?

Possibly, but there is no guarantee. Reopen Excel and check File > Info > Manage Workbook > Recover Unsaved Workbooks. If no suitable recovery copy is listed, Excel may have discarded the unsaved changes.

How do I recover an Excel file that was saved over?

If the file is in OneDrive or SharePoint, check Version history and open a version from before the overwrite. For a local workbook, check any backup or File History system your computer or organization uses; AutoRecover may contain a recent working copy, but it is not a complete version archive.

Why is Recover Unsaved Workbooks missing?

Excel may have no temporary recovery files to offer, or you may be using Excel for the web, which does not use that same desktop command. Check the desktop app’s Save settings and AutoRecover location, then search cloud storage if the file was saved online.

Does AutoSave recover a workbook I never saved?

Usually not as a normal cloud workbook. AutoSave protects supported files that have been saved to OneDrive or SharePoint. Save a new workbook to the cloud first, then confirm synchronization, to benefit from ongoing saves and cloud version history.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.