What happens to unsaved Excel files

When you close Excel without saving, the file does not vanish when ready. Excel keeps a temporary copy on your computer for a set period, and you can often recover it. The exact steps depend on which version of Excel you use and whether you've closed the program already.

Microsoft Excel stores unsaved work in two places: a recovery file that updates while you work, and an autosave backup that it creates at intervals. If you catch the problem before restarting your computer, recovery is usually straightforward. If you've already closed Excel or restarted, the process takes a few more steps but still works most of the time.

Key Takeaways

  • If Excel is still open, go to File > Info > Manage Versions and look for "Recover Unsaved Workbooks" at the bottom of the menu.
  • If you've closed Excel, open it again, go to File > Open > Recent, and look for a "Recover Unsaved Workbooks" button.
  • On Windows, you can also search your computer for .xlsx files modified in the last hour to find temporary recovery files in the AppData folder.
  • Excel's autosave feature (turned on by default in Microsoft 365) saves your work every few minutes if you have OneDrive or SharePoint enabled.
  • If none of these methods work, check your Recycle Bin or Trash folder — you may have accidentally deleted a saved version.

Recovering an unsaved file while Excel is still running

If you realize you didn't save before closing the file but Excel itself is still open, the fastest recovery method is the Manage Versions menu. Click File in the top left, then click Info. Look for a button or link that says "Manage Versions" or "Recover Unsaved Workbooks." Click it.

A window will open showing any unsaved versions of your file. The list shows the date and time each version was created. Click the version you want, and Excel will open it in a new window. Once it opens, save it when ready with File > Save As to give it a permanent name and location.

Recovering a file after you've closed Excel

Open Excel again. Click File in the top left, then click Open. On the left side of the screen, look for "Recent" and click it. At the bottom of the Recent files list, you should see a button that says "Recover Unsaved Workbooks." Click it.

A folder window will open showing temporary files Excel created. These files have names like "Book1" or "Sheet1" with a date stamp. Open the one that matches the time you were working. Once it opens in Excel, save it when ready with a real filename so you don't lose it again.

Finding recovery files on Windows manually

If the Recover Unsaved Workbooks button doesn't appear, you can search for the temporary files directly. Press Windows key + R to open the Run dialog, type %appdata%\Microsoft\Excel, and press Enter. This opens the folder where Excel stores recovery files.

Look for files with names like "Book1" or numbered files with no extension, or files ending in .xlsx that were modified around the time you were working. Right-click any file that looks like yours, click Open With, and choose Excel. If it opens your work, save it with File > Save As and give it a permanent name.

If that folder is empty, try searching your entire computer. Press Windows key + S, type *.xlsx in the search box, and add a filter for "Date modified" set to "Last hour" or "Last day." Look through the results for files in the AppData folder that match your work.

Finding recovery files on Mac

Open Finder and press Command + Shift + G to open the Go to Folder dialog. Type ~/Library/Containers/com.microsoft.Excel/Data/Library/Autosave Information and press Enter. This folder contains Excel's recovery files on Mac.

Look for files with names matching your work or the time you were working. Double-click any file to open it in Excel. If it contains your work, save it when ready with File > Save As and give it a permanent filename.

Using OneDrive or SharePoint autosave

If your Excel file was stored on OneDrive or SharePoint, autosave may have already saved your work without you pressing Save. Open OneDrive or SharePoint in your web browser, find the file, and right-click it. Look for an option called "Version history" or "See all versions." Click it to see a list of every saved version with timestamps.

Click the version closest to when you were working. Excel will open that version. If it contains your work, you're done — the file is already saved. If you want to restore an older version as the main file, click "Restore" next to that version's timestamp.

Preventing this from happening again

Turn on autosave if you use Microsoft 365 with OneDrive or SharePoint. Open any Excel file stored in one of those locations, and look for the autosave toggle in the top left corner of the screen, next to the filename. Click it to turn autosave on. Once it's on, Excel saves your work automatically every few minutes without you doing anything.

If you use Excel without OneDrive or SharePoint, set up automatic recovery instead. Open Excel, click File, then Options. Click Save on the left side. Check the box next to "Keep the last autosaved version if I close without saving," and set the autosave interval to a number of minutes (10 minutes is common). Click OK. Now Excel will keep a backup copy even if you close without saving.

Frequently Asked Questions

How long does Excel keep unsaved files?

Excel keeps unsaved recovery files for four days by default. After four days, it deletes them. If you're looking for a file you didn't save more than four days ago, recovery is unlikely to work. This is another reason to turn on autosave or automatic recovery.

Can I recover a file if I force-closed Excel or my computer crashed?

Yes. When Excel restarts, it usually shows a recovery pane automatically with any files that were open when it crashed. Click the file to open it. If the recovery pane doesn't appear, use the Recover Unsaved Workbooks method described above.

What if I see multiple recovery files and don't know which one is mine?

Open each one. The filename or the content inside will tell you which is the right file. Once you find it, save it with a clear name like "ProjectName_Final" so you can find it again. Then delete the other recovery files so they don't clutter your folder.

Does Excel autosave work if I'm offline?

Autosave to OneDrive or SharePoint requires an internet connection. If you're offline, autosave pauses and resumes when you reconnect. Local automatic recovery (the backup Excel keeps on your hard drive) works offline and doesn't require internet.

Can I recover a file if someone else opened it after I closed it without saving?

If they opened it and saved it, your unsaved version is gone. The recovery files are replaced by the new saved version. This is why it's important to tell others you're working on a file, or to use shared files on OneDrive or SharePoint where you can see version history.