What happens to unsaved Excel files

When you close Excel without saving, the file itself disappears — but Excel keeps a temporary copy on your computer for a short time. How long depends on your version and settings. Excel 2016 and later versions keep these temporary files for four days by default. Older versions may keep them for less time. The file is stored in a hidden folder on your hard drive, not in your Documents folder where you'd normally look.

The recovery process is different depending on whether Excel crashed, you closed it without saving, or your computer shut down unexpectedly. Each situation leaves different traces behind. The sooner you act after losing the file, the better your chances — the temporary copy can be overwritten if you open and close other files.

Key Takeaways

  • Excel stores unsaved files in a hidden temporary folder for up to four days, and you can recover them through the File menu without needing special software.
  • If Excel crashed or your computer shut down, check the "Recover Unsaved Documents" option in File > Open first — this is the fastest route.
  • For files you closed without saving, you can also check the AutoRecover folder directly if the File menu recovery does not show the file.
  • Do not open other Excel files or restart your computer until you have attempted recovery, because this can overwrite the temporary copy.
  • Once you recover the file, save it when ready with a new name to avoid losing it again if something goes wrong during the recovery process.

Recover through the File menu (works for most situations)

Open Excel and go to File > Open. At the bottom of the window, look for a button that says Recover Unsaved Documents or Recover Unsaved Workbooks — the exact wording depends on your Excel version. Click it. A folder window will open showing any unsaved files Excel has stored. Look for the file by name or by the date it was last worked on.

When you find the file you want, click it once to select it, then click the Open button. The file will open in Excel. At the top of the window, you may see a yellow bar saying the file is a recovered version. Do not close this file yet. Instead, go to File > Save As and save it with a new name in a folder you choose. This creates a permanent copy and prevents the file from being deleted from the temporary folder.

Recover from the AutoRecover folder directly

If the Recover Unsaved Documents button does not show your file, you can look in the AutoRecover folder yourself. This folder is hidden by default, so you need to show hidden files first. On Windows, open File Explorer, go to View, and check the box for Hidden items. On Mac, open Finder, press Command + Shift + Period to show hidden files.

The AutoRecover folder location varies by version and operating system. On Windows with Excel 2016 or later, navigate to C:\Users\[Your Username]\AppData\Local\Microsoft\Office\UnsavedFiles. On Mac, go to ~/Library/Containers/com.microsoft.Excel/Data/Library/Autosave Information. Look for files with names like "Book1" or partial names matching your file. These files may not have a .xlsx extension — they might show as just a name with no extension, or with an extension like .xlk. Right-click the file, choose Open With, and select Excel.

What to do if Excel crashed or your computer shut down

When Excel crashes or your computer loses power, Excel's AutoRecover feature may have saved a version automatically. The next time you open Excel, it should show a recovery pane on the left side of the screen listing files it found. Click the file name to open it. If you do not see the recovery pane, go to File > Open and look for Recover Unsaved Documents as described above.

If Excel does not show a recovery pane and the Recover Unsaved Documents folder is empty, check whether AutoRecover was turned on. Go to File > Options (or Preferences on Mac) > Save. Look for a checkbox that says AutoRecover information every [X] minutes. If it is unchecked, AutoRecover was not running, which means no automatic backup was made. In this case, the file may not be recoverable through Excel's built-in tools.

Recover from cloud storage if you use OneDrive or SharePoint

If you were working on a file stored in OneDrive or Microsoft SharePoint, you have another recovery option. These services keep version history automatically. Open OneDrive or SharePoint in your web browser, find the file, right-click it, and look for Version history or See all versions. You will see a list of saved versions with timestamps. Click the version you want to restore, then click Restore. This will replace the current file with that older version.

Version history is not the same as recovery of unsaved work — it only shows versions that were actually saved. But if you saved the file once and then made changes without saving, you can restore the last saved version and redo the work you remember. OneDrive keeps version history for 93 days by default, so even if you lost the file weeks ago, you may still be able to recover an older version.

Why recovery sometimes fails and what to do next

Recovery fails most often because the temporary file was overwritten. This happens when you open and close other Excel files after losing the original file, or if your computer has been restarted. It can also fail if AutoRecover was turned off, or if the file was so new that no automatic backup was created yet. If you have waited more than four days since the file was lost, the temporary copy may have been deleted automatically.

If recovery through Excel does not work, you can try third-party file recovery software like EaseUS Data Recovery or Recuva. These programs scan your hard drive for deleted files and may find traces of the Excel file. However, they work best if you have not saved other files since losing the original — each new file written to your drive makes recovery less likely. read and run the software on the same computer where the file was lost, and search for .xlsx files or by the file name you remember.

Prevent this from happening again

The most reliable way to avoid losing unsaved work is to turn on AutoSave if you use Excel through Microsoft 365 or OneDrive. Go to File > Options > Save and check AutoRecover information every [X] minutes. Set it to save every 1 or 2 minutes. You can also enable AutoSave in the top left of the window if your file is stored in OneDrive or SharePoint — this saves every change automatically without you pressing Ctrl+S.

For files stored on your local computer, get in the habit of pressing Ctrl+S (or Command+S on Mac) every few minutes while working, especially after making important changes. You can also set Excel to prompt you to save when you try to close a file without saving — go to File > Options > Advanced, scroll down, and look for options about closing without saving.

Frequently Asked Questions

How long does Excel keep unsaved files?

Excel 2016 and later keep unsaved files for four days by default. Older versions may keep them for one to three days. The exact time depends on your settings and how much disk space your computer has. Once the four days pass, the temporary file is deleted and cannot be recovered through Excel's built-in tools.

Can I recover a file if I never saved it even once?

If AutoRecover was turned on, yes — Excel creates temporary backups automatically every few minutes. If AutoRecover was off, recovery is much harder and depends on whether third-party recovery software can find traces of the file on your hard drive. This is why turning on AutoRecover in your settings is important.

What if the recovered file is corrupted or shows strange characters?

Recovered files are sometimes incomplete or partially corrupted, especially if the recovery happened after a crash. Try opening it anyway — Excel often repairs minor corruption automatically. If it does not open, try opening it in a different version of Excel if you have access to one. You can also try opening it as a CSV file instead of .xlsx, though you may lose formatting.

Does restarting my computer delete the unsaved file?

Restarting does not delete it when ready, but it can make recovery harder. The temporary file stays on your hard drive, but if you open other files after restarting, they may overwrite the space where the temporary file is stored. Try recovery as soon as possible after losing the file, before opening other programs.

Can I recover a file someone else was working on?

If the file was stored in OneDrive or SharePoint, you can see version history if you have permission to access the file. If it was stored on their local computer, you cannot recover it from your computer — you would need access to their machine and their AutoRecover folder. Ask them to check their own File > Recover Unsaved Documents first.