Where Excel Stores Unsaved Work
Excel automatically saves a temporary copy of your work every 10 minutes by default, even if you have never saved the file yourself. This temporary file is stored separately from your actual spreadsheet and stays on your computer even after you close Excel without saving. The location depends on which version of Excel you use and your operating system.
On Windows with Excel 2016 or later, unsaved files are typically stored in C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles. On a Mac with Excel 2016 or later, look in ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles. If you use an older version of Excel, the folder location differs — Excel 2013 and earlier store recovery files in a different AppData subfolder.
Key Takeaways
- Excel keeps automatic temporary copies of unsaved work in a hidden folder on your computer, separate from your actual files.
- The Document Recovery pane appears automatically when you reopen Excel after a crash, but you must act quickly because these temporary files are deleted after a set period.
- If Document Recovery does not appear, you can manually navigate to the UnsavedFiles folder and look for your spreadsheet by date and time.
- Changing the AutoRecover interval in Excel settings lets you control how often the program saves temporary copies, with more frequent saves using more disk space.
- Once you recover a file, save it when ready with a permanent filename to prevent losing it again.
Using the Document Recovery Pane After a Crash
When Excel crashes or closes unexpectedly, the Document Recovery pane usually appears the next time you open the program. This pane lists any unsaved files that Excel detected when it shut down. Each file shows the date and time it was last saved, which helps you identify the right version if you had multiple spreadsheets open.
Click the file you want to recover, then click the Open button. Excel will load the temporary version into a new window. At this point, the file is still temporary — it will disappear if you close Excel without saving. You must when ready save it with a permanent filename by pressing Ctrl+S (Windows) or Command+S (Mac), then choose a location and give it a name. If you do not save within a few days, Excel automatically deletes the temporary file.
If the Document Recovery pane does not appear, it may mean Excel did not detect an unsaved file, or the temporary file has already been deleted. In that case, move to the manual recovery method described in the next section.
Manually Finding Temporary Files in the UnsavedFiles Folder
If Document Recovery does not appear, you can search for temporary files yourself. On Windows, open File Explorer and paste this path into the address bar: %appdata%\Microsoft\Office\UnsavedFiles. Windows will automatically expand %appdata% to the correct hidden folder. On a Mac, open Finder, press Command+Shift+G to open the Go to Folder dialog, then paste ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles.
Look for files with names like Book1, Sheet1, or the actual filename you were working on. Files in this folder are sorted by date modified, so the most recent ones appear at the top. Right-click the file you want and select Open With, then choose Excel. The file will open as a temporary document. Save it when ready with Ctrl+S or Command+S, choose a permanent location, and give it a proper filename.
If the UnsavedFiles folder is empty or does not exist, the temporary files have been deleted. This happens automatically after a set number of days — by default, Excel keeps temporary files for up to four days. If your file is not there, you may need to check whether you have a backup from another source, such as cloud storage or an external drive.
Adjusting AutoRecover Settings to Save More Frequently
By default, Excel saves a temporary copy every 10 minutes. If you work on large or complex spreadsheets, or if you frequently lose power or have crashes, you can change this interval to save more often. On Windows, click File, then Options, then Save. Look for the section labeled AutoRecover. Check the box next to Save AutoRecover information every X minutes, then change the number to a smaller value — 5 minutes is common for people who want more frequent saves.
On a Mac, click Excel in the menu bar, then Preferences, then Save. Find the AutoRecover section and adjust the interval the same way. Saving more frequently uses slightly more disk space and can slow down your computer if you are working with very large files, but for most people the trade-off is worth it.
You can also check the box labeled Keep the last AutoRecovered version if I close without saving. This tells Excel to preserve the temporary file even if you deliberately close the spreadsheet without saving, which is useful if you change your mind later.
When Recovery Files Are Deleted
Excel does not keep temporary files forever. By default, unsaved files are deleted after four days of inactivity. If you do not open Excel during that time, or if you do not open the specific file, the temporary version disappears. Some organizations change this setting — your workplace IT department may have set it to delete files after one day or to keep them for a week.
If you recover a file and then close Excel without saving, the temporary copy is replaced with a new one the next time you open that file. This means if you recover a spreadsheet, make changes, and close without saving, you will lose those new changes but the original recovered version will still be available the next time you open Excel.
Preventing Data Loss Going Forward
The most reliable way to avoid losing unsaved work is to save your file with a permanent name as soon as you start working on it, rather than waiting until you are done. Press Ctrl+S or Command+S when ready after opening a new spreadsheet, choose a location, and type a filename. After that, Excel will update the same file each time you save, and you will have a permanent copy on your computer.
If you use OneDrive, Google Drive, or another cloud storage service, save your Excel files there instead of your local hard drive. Cloud storage automatically backs up your work and keeps version history, so you can recover older versions even if your computer fails. Excel also has a built-in autosave feature for files stored in OneDrive or SharePoint — if you enable it, the file saves automatically every few seconds without you pressing Ctrl+S.
Frequently Asked Questions
How long does Excel keep unsaved files?
By default, Excel keeps temporary unsaved files for four days. If you do not open Excel during that time, the files are deleted automatically. You can change this setting in Excel Options under Save, but the exact number of days depends on your version and whether your organization has changed the default.
Can I recover a file if I did not see the Document Recovery pane?
Yes. Open File Explorer or Finder and navigate to the UnsavedFiles folder using the paths listed above. Look for files sorted by the date you were working on them. If the folder is empty, the temporary files have been deleted and recovery may not be possible.
What if I closed Excel on purpose without saving — can I still recover it?
Yes, as long as the temporary file has not been deleted. Excel keeps the temporary version even after you close the program deliberately. Open Excel again and check the Document Recovery pane, or navigate to the UnsavedFiles folder manually.
Does AutoRecover work if my computer crashes?
Yes. AutoRecover saves a temporary copy to your hard drive every 10 minutes (or whatever interval you set), so the file survives a crash. When you restart Excel, the Document Recovery pane will show the recovered version. However, you will lose any work done in the last few minutes before the crash.
Should I turn off AutoRecover to save disk space?
No. AutoRecover uses very little disk space — temporary files are typically small and are deleted automatically after four days. Turning it off removes your safety net without any meaningful benefit. Keep it on and adjust the interval if needed.