Where Excel stores unsaved work
Excel automatically saves a temporary copy of your work every ten minutes, even if you never pressed Save. This copy lives in a hidden folder on your computer, separate from your actual file. If you closed the file without saving, or your computer crashed, that temporary version is still there — you just have to know where to look.
The location depends on your operating system and which version of Excel you use. Windows stores these files in a folder buried several levels deep. Mac does the same but in a different location. The file won't have your original name — it will be a recovery file with a generic name — but the content inside is what you were working on.
Key Takeaways
- Excel saves a temporary copy of your work every ten minutes automatically, even if you never pressed Save yourself.
- On Windows, recovery files are in AppData\Local\Microsoft\Office\UnsavedFiles; on Mac, they are in Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles.
- If Excel crashed or you force-closed it, check the Document Recovery pane the next time you open Excel — it appears automatically and lists recoverable files.
- If you closed the file normally without saving, you must navigate to the recovery folder manually and look for files with today's date.
Using the Document Recovery pane on Windows
If Excel crashed or your computer lost power while the file was open, Excel will show you a Document Recovery pane the next time you launch it. This pane lists files it can recover, with the date and time each was last saved. Click the file you want, and Excel opens it in a new window.
Once the file is open, save it when ready with a real filename in a location you can find — your Documents folder or Desktop. Do not close Excel without saving, or you will lose the recovered content again. If the Document Recovery pane does not appear, the file may have been closed normally rather than crashed, and you will need to search the recovery folder manually instead.
Finding the recovery folder on Windows
Open File Explorer and navigate to the address bar at the top. Type this path exactly: %AppData%\Local\Microsoft\Office\UnsavedFiles and press Enter. Windows will take you directly to the folder where Excel stores temporary files.
Look for files with today's date. They will have names like "Book1" or "Sheet1" with no extension, or with an extension like .xlsx. Open the one that looks like your file — check the file size and date to narrow it down if there are several. When you open it, Excel will ask whether to recover the file or discard it. Choose recover, then save it with your real filename.
If the folder is empty or you do not see a file from today, the temporary file may have been deleted. This happens if you restarted your computer or if Excel was force-closed more than a few hours ago. In that case, check your Recycle Bin — if you deleted the original file by accident, it may still be there.
Finding the recovery folder on Mac
Open Finder and press Command+Shift+G to open the "Go to Folder" dialog. Type this path: ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles and press Enter. Finder will navigate to the recovery folder.
Look for files with today's date. Open the one that matches your spreadsheet — check the file size and modification time if there are multiple files. When you open it, Excel will ask whether to recover the file. Choose recover, then save it with your real filename to a location you can find, like your Documents folder.
If the folder is empty, the temporary file has been deleted. Check your Trash — if you deleted the original file by accident, you may be able to restore it from there. If the file is not in Trash either, the recovery file is gone and cannot be retrieved.
What to do if the recovery folder is empty
If you cannot find a recovery file, the temporary copy has been deleted. This usually happens because the file was closed normally (not crashed), and Excel deleted the temporary version after a few days. Once that temporary file is gone, there is no way to recover the unsaved work.
Check your Recycle Bin (Windows) or Trash (Mac) to see if you deleted the original file by accident. If it is there, restore it — you will get back whatever was last saved, not the unsaved changes, but at least you have something. If the original file is not in the trash either, and there is no recovery file, the work is lost.
This is why the backup strategy from the previous section matters: if you had been saving regularly to a cloud service like OneDrive or Google Drive, or to an external drive, you would have a recent copy even if today's work is gone. Going forward, enable AutoSave if you use Excel on OneDrive or SharePoint, or get in the habit of pressing Ctrl+S (Windows) or Command+S (Mac) every few minutes while you work.
Preventing this from happening again
The simplest fix is to turn on AutoSave. If your file is stored on OneDrive, SharePoint, or OneDrive for Business, open the file and look for the AutoSave toggle in the top left corner of Excel. Turn it on, and Excel will save your changes automatically as you type — you will never lose unsaved work again.
If your file is stored locally on your computer (not in the cloud), AutoSave is not available, but you can still save frequently. Press Ctrl+S on Windows or Command+S on Mac every few minutes. Many people set a timer on their phone as a reminder until the habit sticks. You can also enable the AutoRecover feature in Excel settings, which increases how often Excel saves temporary copies — though this does not replace actually saving the file yourself.
Another option is to save your file to OneDrive or Google Drive instead of keeping it only on your computer. Both services keep version history, so even if you save over a file by accident, you can restore an earlier version. This protects you not just from crashes, but from your own mistakes.
Frequently Asked Questions
How long does Excel keep temporary recovery files?
Excel keeps temporary files for about three to four days after the file is closed. If you do not recover the file within that window, the temporary copy is deleted automatically. If you realize you need the file more than a few days later, the recovery folder will be empty.
Can I recover a file if I closed Excel without saving?
Yes, if you closed it recently — within the last few days. You must navigate to the recovery folder manually because the Document Recovery pane only appears after a crash. Look for files with today's date or yesterday's date, and check the file size to identify the right one.
What if there are multiple files in the recovery folder?
Check the file size and modification time for each one. The file you want is usually the largest one with the most recent timestamp. You can also open each one to peek inside before deciding which to recover. Once you recover the right file, save it with a clear filename so you can find it again.
Does AutoSave work with files stored on my computer?
No. AutoSave only works if your file is stored on OneDrive, SharePoint, or OneDrive for Business. If your file is on your local hard drive, you must save it manually or enable AutoRecover in Excel settings, which increases the frequency of temporary backups but does not replace actually saving the file.
Can I recover a file if my computer crashed and won't start?
Not from that computer. If the computer will not start, you cannot access the recovery folder. However, if you had been saving to OneDrive or another cloud service, you can log into that service on another computer and read your file from there. This is another reason cloud backup matters.