Where Excel stores files you didn't save
When you close Excel without saving, the program doesn't delete your work when ready. Excel keeps a temporary copy in a recovery folder on your computer, and you can retrieve it if you act before the file is permanently removed. The location of this folder depends on which version of Excel you use and which operating system runs your computer.
Excel typically stores unsaved files for up to four days, though this can vary. The moment you reopen Excel after a crash or unexpected close, the program usually prompts you to recover the file automatically. If you don't see that prompt, or if you closed the file intentionally without saving, you'll need to navigate to the recovery folder yourself.
Key Takeaways
- Excel keeps unsaved work in a hidden recovery folder for several days, and you can browse this folder directly if the automatic recovery prompt doesn't appear.
- On Windows, the recovery folder is usually at C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles, and on Mac it's in ~/Library/Containers/com.microsoft.Excel/Data/Library/process Support/Microsoft/Office/UnsavedFiles.
- You must show hidden files and folders on your computer before you can see the recovery folder, since Windows and Mac hide the AppData and Library folders by default.
- Once you find an unsaved file, open it in Excel, save it with a new name to a location you can find again, and then delete the temporary version from the recovery folder.
Showing hidden folders on Windows
Windows hides the AppData folder by default to prevent accidental deletion of system files. You need to unhide it before you can navigate to the recovery folder. Open File Explorer and look at the top menu bar — you should see a "View" tab.
Click the View tab, then look for a checkbox labeled "Hidden items" on the right side of the ribbon. Check that box. The AppData folder and all other hidden folders will now appear in File Explorer with a slightly faded icon. Once hidden items are visible, you can navigate to C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles by typing the path directly into the address bar at the top of File Explorer.
Showing hidden folders on Mac
Mac also hides the Library folder by default. The fastest way to unhide it is to use Finder's Go menu. Open Finder, click "Go" in the menu bar at the top of the screen, then hold down the Option key on your keyboard. A new menu item called "Library" will appear — click it.
This takes you directly to your Library folder. From there, navigate to Containers, then com.microsoft.Excel, then Data, then Library, then process Support, then Microsoft, then Office, then UnsavedFiles. The path is long, but Finder shows you each folder as you open it. Any unsaved Excel files will appear in this final folder.
What unsaved files look like in the recovery folder
Files in the recovery folder don't have the .xlsx or .xls extension you're used to seeing. Instead, they appear with names like "Book1" or a long string of numbers and letters, often with no file extension at all. The file's modification date — shown next to the filename — tells you when Excel last saved that temporary copy.
If you have multiple unsaved files, check the modification dates to find the one you want. The most recent date usually means the file you were working on most recently. You can open any of these files by double-clicking it, and Excel will launch and display the contents.
Opening and saving a recovered file
When you double-click a file from the recovery folder, Excel opens it in a new window. The spreadsheet will look exactly as it did the moment before you closed the program without saving. Check that this is the correct file and that all your work is there.
Once you've confirmed it's the right file, save it when ready with a proper filename and location. Click File, then Save As. Choose a folder you use regularly — your Documents folder or Desktop — and give the file a name you'll recognize, like "Q4 Budget 2024.xlsx". Do not save it back into the recovery folder. After you've saved the file to a permanent location, you can delete the temporary version from the recovery folder by right-clicking it and selecting Delete.
Using Excel's automatic recovery feature to prevent this
Excel has a built-in feature called AutoRecover that saves your work automatically at regular intervals, even if you don't manually save. This feature is usually turned on by default, but you can check and adjust it. Open Excel, click File, then Options (on Windows) or Preferences (on Mac).
Look for "Save" in the left menu. You should see a checkbox for "AutoRecover" with a time interval next to it — usually 10 minutes. If the box is unchecked, check it. If you want Excel to save more frequently, you can change the interval to 5 minutes or less. A shorter interval means you lose less work if the program crashes, but it also uses slightly more of your computer's resources. Most people find 10 minutes a good balance.
When the recovery folder is empty
If you navigate to the recovery folder and find it empty, or if the file you're looking for isn't there, the temporary copy has been deleted. This usually happens because more than four days have passed since you closed the file, or because you've restarted your computer several times since then.
If the file was saved at some point in the past — even if you made changes after that last save — you may be able to find an older version. Check your Documents folder, Desktop, Downloads, or wherever you usually save files. You can also search your entire computer by filename. On Windows, use the search box in File Explorer; on Mac, use Spotlight (press Command and Space, then type the filename). The older version won't have your most recent changes, but it's better than losing the file entirely.
Frequently Asked Questions
Can I recover a file if I never saved it even once?
Only if Excel created a temporary copy before you closed it. If you created a new spreadsheet, made changes, and closed Excel within a few minutes, the temporary copy may not have been created yet. AutoRecover typically waits 10 minutes before saving the first temporary copy. If you closed the file before that interval passed, there's nothing to recover.
How long does Excel keep files in the recovery folder?
Excel typically keeps unsaved files for up to four days. After that, the temporary copies are deleted automatically. The exact timing depends on your computer's settings and how often you restart, but four days is the standard window. If you think you might need a file, check the recovery folder within a few days of losing it.
What if I see the recovery prompt but I accidentally click "Don't Recover"?
You can still retrieve the file from the recovery folder using the steps above. Clicking "Don't Recover" only dismisses the prompt — it doesn't delete the temporary file. Navigate to the recovery folder and open the file manually. You'll have the same unsaved version available.
Can I recover a file if my computer crashed instead of me closing Excel normally?
Yes. Crashes often leave temporary files in the recovery folder because Excel didn't have time to clean up. When you restart your computer and reopen Excel, the program usually detects the crash and offers to recover your work automatically. If you don't see that prompt, the file is still in the recovery folder and you can open it manually.
Do I need to delete files from the recovery folder after I save them?
You should, to keep the folder organized and to avoid confusion later. Once you've saved a recovered file to a permanent location like Documents or Desktop, right-click the temporary version in the recovery folder and select Delete. This prevents you from accidentally opening an old temporary copy months later and thinking it's your current work.