After Excel crashes on Windows, reopen Excel and check the Document Recovery pane first; open the newest recovered version and save it with a new name. If it does not appear, look in File > Info > Manage Workbook > Recover Unsaved Workbooks, or check Excel’s AutoRecover folder at %LocalAppData%\Microsoft\Office\UnsavedFiles. The right place depends on whether the workbook had been saved before the crash.
Where Excel stores recovery files
Excel does not put every crashed workbook in one permanent, guaranteed location. It may hold a temporary recovery copy, show a version in Document Recovery, or save recovery data in a folder configured in Excel’s options. A workbook that had already been saved normally remains in its original folder; the recovery copy, if one exists, may be separate.
To check the usual unsaved-workbook location, open File Explorer, click the address bar, enter %LocalAppData%\Microsoft\Office\UnsavedFiles, and press Enter. This Windows path expands to the current user’s local application-data folder. If the folder opens, look for recently modified files that may correspond to the workbook. Names and file types can vary, so sort by Date modified and inspect plausible candidates rather than relying on one exact filename.
Excel also lets you check or change its AutoRecover folder. In Excel for Microsoft 365 on Windows, go to File > Options > Save and read the path beside AutoRecover file location. You can copy that path into File Explorer. If your organization or a previous setup changed the location, this setting is more useful than assuming the default folder. A folder may be empty if Excel did not create a recovery copy, or if cleanup, storage settings, or the crash itself removed or prevented one.
What to do immediately after Excel crashes
Act promptly, but avoid opening and closing many copies of Excel or deleting temporary files while you search. When Excel restarts after an unexpected shutdown, it may display Document Recovery along the left side of the window. That pane can list one or more recovered versions, often with a time or status that helps distinguish them.
- Open Excel again and wait for any recovery pane to finish loading.
- Open the most recent plausible version. If there are several, check each one for the changes you need.
- Use File > Save As and save a separate copy to a familiar folder, such as Documents. Give it a new name so you do not accidentally overwrite the original.
- After confirming the saved copy opens and contains the needed work, decide whether to replace or retain the older workbook.
If Excel opens normally without showing a recovery pane, check the recovery and unsaved-workbook locations before assuming the file is gone. Do not choose an option such as Delete or Discard for a recovery entry until you have opened and saved any version you might need. A recovered workbook is not always the same as the last manually saved version.
Find the original saved workbook
If you had saved the workbook before the crash, start with its normal location. Check the folder where you last saved it, plus common destinations such as Documents, Desktop, or a work or school OneDrive folder. In Excel, File > Open > Recent can show recently opened workbooks; select an entry to open it, or use its context menu or file-location option if available to locate the file. A Recent entry is a pointer to a workbook, not necessarily a separate recovery copy.
If you cannot remember the folder, search in File Explorer for part of the workbook’s name, or search for Excel workbooks using extensions such as .xlsx, .xlsm, or .xls. Search This PC or likely folders, then sort results by Date modified. A recent timestamp can help identify the right file, but it is not proof that the file contains the latest unsaved edits. Avoid opening files with unfamiliar names from unrelated folders, particularly if they arrived by email or download.
For a workbook that was open when Excel crashed, compare the original file with any recovered copy before replacing anything. The original may contain all changes through the last save, while the recovery copy may contain some later edits. Saving the recovered version under a new name preserves both candidates and makes it easier to compare sheets or confirm that formulas, charts, and data are intact.
Recover a workbook that was never saved
For a new workbook that had no filename yet, use Excel’s unsaved-workbook recovery command. In Excel for Microsoft 365 on Windows, try File > Info > Manage Workbook > Recover Unsaved Workbooks. In some builds, the link is easier to find under File > Open > Recent, near the bottom of the Recent list. Open a candidate file, then use Save As to give it a permanent name and location.
This route is especially relevant if you created a blank workbook, entered data, and Excel closed before you saved it for the first time. It may also help if you selected Do not save when closing a workbook, provided Excel retained an AutoRecover version. It cannot guarantee recovery: Excel must have created a usable recovery copy, and the copy must still be available. Work entered after the most recent recovery snapshot may be missing.
AutoRecover is a safety feature, not a continuous substitute for saving. Its timing is controlled in File > Options > Save under Save AutoRecover information every. The interval is often set to 10 minutes by default, but the setting can differ. The same area includes Keep the last autorecovered version if I close without saving; check whether it is enabled if you want that additional protection. On Mac, Excel’s Preferences and recovery locations differ, so Windows folder paths and Windows menu instructions do not apply directly.
Check OneDrive or SharePoint versions
If the workbook was stored in OneDrive or SharePoint, check the cloud copy as well as Excel’s local recovery options. When AutoSave is on for a supported cloud-stored workbook, Excel saves changes automatically as you work. After a crash, reopen the file from its cloud location and check whether the latest edits are present. AutoSave depends on the file being in a supported cloud location and available connectivity; it is not the same setting as AutoRecover.
Cloud version history can provide another way to retrieve an earlier state. In Excel, try File > Info > Version History for a workbook stored in OneDrive or SharePoint. You can also locate the file in OneDrive on the web or in the SharePoint library and use its Version history command. Review the dates before restoring a version. If you need the current version preserved too, download or save a copy before restoring an older one.
If the workbook was deleted rather than merely affected by a crash, check the OneDrive recycle bin or, for a work or school SharePoint file, the relevant site’s recycle bin if you have access. Recycle-bin retention and recovery permissions can depend on the account and organization. A local folder’s Windows Recycle Bin is also worth checking for a file that was deleted from the PC, but it will not normally contain a recovery copy made by Excel.
Understand recovery files and common mix-ups
Several things that look like temporary Excel files are not necessarily usable workbook backups. In particular, a filename beginning with ~$ is commonly an ownership or lock file created while a workbook is open. It helps coordinate access to the workbook; it usually does not contain the workbook’s data and should not be treated as the recovered spreadsheet. Do not rename it to .xlsx expecting it to restore your work.
Likewise, a file with a recent timestamp is only a candidate. Open it from Excel where possible, check the sheets and last entries, and save a verified copy before making changes. If Excel reports that a file is damaged, first make a duplicate of the candidate so you preserve the original. Then try opening the copy with Excel’s available repair prompt. Repair may not restore every formula, formatting choice, chart, or external connection.
One common misconception is that Excel can recreate every keystroke after a crash. It cannot. AutoRecover stores recovery information at intervals, and a sudden power loss, full disk, forced shutdown, or damaged file may interrupt that process. Changes since the most recent valid recovery point may be lost. A workbook stored in a synchronized folder can also have both local and cloud states, so check timestamps and version history rather than assuming one automatically reflects every edit.
If you cannot find the workbook
Work through likely locations in a deliberate order: Document Recovery, Recover Unsaved Workbooks, the configured AutoRecover folder, the workbook’s original folder, and any OneDrive or SharePoint version history. Search by a distinctive part of the filename and by likely Excel extensions. If the filename is unknown, search recently modified files in the folders where you normally work and inspect candidates carefully.
If Excel crashed while saving, the result can be less predictable than a crash during ordinary editing. Check whether the original file still opens before attempting repair. If it does not, make a copy of it and work on the copy. For a work-managed computer, ask IT before using recovery utilities or changing permissions; organization policies, encryption, and backups may affect what is available. Avoid downloading unknown recovery software or uploading a confidential workbook to an untrusted online service.
If no recovery entry, AutoRecover file, cloud version, or backup exists, Excel may have no remaining copy to restore. That is frustrating, but repeatedly changing file extensions or deleting temporary files will not reliably reconstruct missing data and can make investigation harder. Preserve any plausible candidate files and seek help from your organization’s support team if the workbook is business-critical.
Reduce the chance of losing work next time
Use regular saves as the primary safeguard. Save a new workbook early with a meaningful filename and location, then press Ctrl+S on Windows as you work. The Mac equivalent is Command+S. For cloud-stored files where it is available, turn on AutoSave and confirm that the workbook is actually saved in OneDrive or SharePoint; the AutoSave switch is not a promise that offline edits have already synchronized.
Also review File > Options > Save periodically to confirm the AutoRecover interval and the option to retain the last recovered version. A shorter interval can reduce the amount of work between recovery snapshots, though it still does not eliminate risk. Keep independent backups for important work, and be cautious about editing a single copy on removable storage or a network connection that is unreliable. If Excel crashes repeatedly, update Microsoft 365 through File > Account > Update Options > Update Now, where that option is available, and ask IT for help if updates are managed by your organization.
Frequently Asked Questions
Where are unsaved Excel files stored on Windows?
First check File > Info > Manage Workbook > Recover Unsaved Workbooks. You can also inspect %LocalAppData%\Microsoft\Office\UnsavedFiles and confirm the configured AutoRecover file location under File > Options > Save.
How do I recover an Excel file after a crash?
Restart Excel and look for the Document Recovery pane. Open the latest suitable version and immediately use Save As to preserve it. If the pane is absent, check Recover Unsaved Workbooks, the AutoRecover folder, and any cloud version history.
Can I recover an Excel file I never saved?
Possibly. Use Recover Unsaved Workbooks and look for a candidate from the time you were working. Recovery depends on whether Excel created and retained a usable AutoRecover copy, so it is not guaranteed.
Does Excel AutoRecover save every change?
No. AutoRecover saves recovery information at intervals set in Excel’s Save options. Edits made since the last usable recovery point can be lost. AutoSave for supported OneDrive or SharePoint files is a separate feature.
What does a file beginning with ~$ mean?
It is usually a temporary lock or ownership file associated with an open workbook, not a backup containing the spreadsheet. Look for the real workbook or an Excel recovery entry instead.
Related
- Undo in Excel: Shortcuts, Limits, and Recovery Tips
- Undo vs Redo Excel: What Each Command Does
- Ungroup Excel Shortcut: Remove Row and Column Groups
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Office 365 Excel Auto Calculation Not Working? FixesIf Excel for Microsoft 365 is not updating formula results, first choose Formulas > Calculation Options > Automatic.…
- Excel #VALUE! Error When a Linked Workbook Is ClosedYes—Excel can return #VALUE! when a formula uses certain functions, such as SUMIF or COUNTIF, to evaluate ranges…
- Excel Conditional Formatting for Errors: Fix & HideTo highlight or hide errors in Excel, use Conditional Formatting with the ISERROR function (or ISNA for #N/A…
- How to Change a Range Name in Excel and Fix ReferencesTo change a named range in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select…
- Excel Solver Not Opening? Fix the Add-InIf Excel Solver is not opening, enable its add-in in desktop Excel: go to File > Options >…
- VLOOKUP Not Working? Causes and FixesIf VLOOKUP is not working, set its final argument to FALSE for an exact match, then check that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.