What happens to unsaved Excel files
When you close Excel without saving, the file does not vanish when ready. Excel keeps temporary copies of your work in a hidden folder on your computer, and it may also have created an auto-recovery file if you had the feature turned on. The length of time these files stay recoverable depends on your version of Excel and your settings — anywhere from a few days to several weeks. The sooner you act after closing the file, the better your chances.
The recovery process differs slightly between Excel on Windows and Excel on Mac, and between the desktop version and Excel online. If you were using Excel online (the version in your web browser through Microsoft 365), recovery is simpler because Microsoft keeps backups on their servers. If you were using the desktop version, you will need to look in your computer's temporary files.
Key Takeaways
- Excel stores unsaved work in a hidden recovery folder, and you can often retrieve it through the File menu without opening a command line or folder path.
- The auto-recovery feature must be turned on in Excel settings to create backup copies; if it is off, your only option is the temporary files folder.
- Excel online automatically saves your work to OneDrive or SharePoint, so you can usually recover recent versions through the version history feature.
- If you cannot find the file through Excel's built-in recovery tools, you may be able to search your computer's temporary files folder, though this requires navigating hidden system folders.
- Once you recover the file, save it when ready with a new name to prevent overwriting it again.
Recovering unsaved files in Excel desktop (Windows)
Open Excel and go to File in the top left corner. Click Open, then look for a button or link that says Recover Unsaved Documents or Recent — the exact wording depends on your Excel version. This will show you a list of files Excel has kept in its recovery folder. If you see your file listed, click it to open it.
If the Recover Unsaved Documents option does not appear, you can also try this path: File > Info > Manage All Versions (or Recover Unsaved Workbooks in older versions). This opens a dialog showing temporary files. Select the one with the most recent date and time, then click Open.
Once the file opens, you will see it is marked as a recovery file. Save it when ready by pressing Ctrl+S or going to File > Save As. Choose a new filename and a location you can find easily — your Documents folder or Desktop. Do not save it back to its original location with the original name until you have confirmed the content is correct.
Recovering unsaved files in Excel on Mac
Open Excel and click File in the menu bar at the top. Look for Open Recent or Recent Workbooks. At the bottom of that menu, you should see Browse Recovered Files or Recover Unsaved Workbooks. Click it to see what Excel has saved.
If that option is not visible, go to File > Info and look for a Manage Versions or Recover Unsaved Workbooks button. Select the file with the date and time closest to when you were working on it, then click Open.
After the file opens, save it with a new name right away. Press Command+S or go to File > Save As. Give it a clear name and save it to a folder you use regularly, like Documents or Desktop.
Recovering files from Excel online
If you were working in Excel online (also called Excel for the web), your file is already backed up on OneDrive or SharePoint. Open the file in your web browser and look for a File menu or an information icon. Click Version History or See All Versions. This shows you every saved version of the file, with timestamps.
Scroll through the list to find a version from before you closed the file without saving. Click on it to preview the content. If it contains the work you lost, click Restore to make that version the current one. Excel online will ask you to confirm; click Restore again. The file is now recovered and saved.
Finding temporary files manually (Windows)
If Excel's built-in recovery tools do not show your file, you can search your computer's temporary files folder directly. This is more technical, but it works when other methods fail. Press Windows key + R to open the Run dialog. Type %appdata%\Microsoft\Excel and press Enter. This opens a folder where Excel stores recovery files.
Look for a folder called XLStart or a file with a name like ~$filename.xlsx (the tilde at the start means it is a temporary file). If you find your file, right-click it and select Copy. Navigate to your Documents folder, right-click in an empty space, and select Paste. Then rename the file by removing the tilde and any extra characters, so it reads filename.xlsx instead.
Open the file in Excel to check that your work is there. If it opens and looks correct, save it again with a permanent name in a location you back up regularly.
Finding temporary files manually (Mac)
On Mac, temporary Excel files are stored in a hidden folder. Open Finder and press Command+Shift+G to open the Go to Folder dialog. Type ~/Library/Containers/com.microsoft.Excel/Data and press Enter. This takes you to where Excel stores its temporary files.
Look for a folder called OfficeFileCache or AutoRecovery. Inside, you may see files with names like ~$filename.xlsx or numbered files without extensions. These are recovery files. Drag the one with the most recent date to your Desktop. Then open it in Excel to see if it contains your work.
If the file opens but does not have a proper name or extension, save it when ready as a new file with a clear name and the .xlsx extension. This prevents Excel from treating it as a temporary file and deleting it later.
Turning on auto-recovery to prevent this next time
Excel has a feature called AutoRecover that saves your work automatically at regular intervals — usually every 10 minutes. If this is turned on, you have a much better chance of recovering lost work. Check whether it is enabled so you know what to expect if this happens again.
On Windows, go to File > Options > Save. Look for a checkbox that says Save AutoRecover information every [X] minutes. If it is unchecked, click it to turn it on. You can also adjust how often Excel saves — 10 minutes is the default, but you can change it to 5 or 15 minutes depending on how much work you want to risk losing.
On Mac, go to Excel > Preferences > Save. Look for AutoRecover and make sure it is checked. You can set how often it saves in the same menu.
What to do if you cannot find the file
If none of the recovery methods above find your file, it may have been deleted from the temporary folder already. This happens when your computer runs low on disk space or when Windows or Mac clears out old temporary files automatically. At this point, recovery through Excel is not possible.
You can try using your operating system's file recovery tool as a last resort. On Windows, third-party tools like Recuva or EaseUS Data Recovery can sometimes retrieve deleted files from your hard drive, though success is not may provide. On Mac, tools like Data Rescue or DiskWarrior may help, but they work best if you stop using your computer when ready after realizing the file is gone — continued use can overwrite the deleted data.
If the file contained important information, consider whether you have notes, emails, or printed copies that document what was in it. Sometimes reconstructing from other sources is faster than waiting for recovery software to work.
Frequently Asked Questions
How long does Excel keep unsaved files?
Excel keeps unsaved files in its recovery folder for several days to several weeks, depending on your version and how often you use the program. The exact timeframe varies, so do not wait — start the recovery process as soon as you realize the file is missing. Files in the temporary folder may be deleted sooner if your computer runs low on disk space.
Can I recover a file if I never saved it even once?
Yes, if AutoRecover is turned on. Excel creates recovery files automatically even if you have never saved the original file. If AutoRecover is off, your chances are much lower, but you can still try searching the temporary files folder manually. If neither works, the file cannot be recovered.
What is the difference between a recovery file and a backup?
A recovery file is a temporary copy Excel creates automatically while you work. A backup is a copy you create intentionally and store separately. Recovery files are meant to be temporary and may be deleted by your operating system. Backups are permanent and under your control. This is why setting up regular backups is more reliable than depending on recovery files.
If I recover the file, will it have all my recent changes?
It will have the changes up to the last time Excel saved a recovery copy — usually within the last 10 minutes if AutoRecover is on. Any work you did after that last auto-save will be lost. This is why turning on AutoRecover and setting it to save frequently is important.
Should I save the recovered file with the same name as the original?
No. Save it with a new name first, like filename_recovered.xlsx. Open it and check that all your work is there and that the data looks correct. Only after you have confirmed the content should you decide whether to keep this version or go back to an older saved version. This prevents you from accidentally overwriting a good file with a corrupted recovery copy.