Where Excel stores files you haven't saved yet

If you closed Excel without saving, or your computer crashed mid-work, Excel keeps a temporary copy. Open Excel and look for a Document Recovery pane on the left side of the screen — it appears automatically when Excel detects unsaved work. Click the file name to open it.

If you don't see the pane, go to File > Open > Recent, then look for a button that says Recover Unsaved Workbooks at the bottom. This opens a folder of temporary files Excel created while you were working.

These temporary files only stay for a few days, so act quickly if you remember closing the file recently. Once you open a recovered file, save it immediately with a real file name — don't wait.

Key Takeaways

  • Excel's Document Recovery pane appears automatically after a crash and shows unsaved work from the last few days.
  • If you deleted a file from your computer, check your Recycle Bin (Windows) or Trash (Mac) first — files stay there until you empty it.
  • OneDrive and Google Drive keep deleted files in a trash folder for 93 days, which is longer than your computer's recycle bin.
  • If you saved over a file by mistake, use File > Info > Version History to see older copies Excel kept automatically.
  • For files deleted weeks ago, you may need to restore from a backup — ask your IT department or check your backup software.

Recovering a file you deleted from your computer

If you deleted an Excel file and want it back, first check your Recycle Bin (on Windows) or Trash (on Mac). Right-click the file and choose Restore — it goes back to the folder where it was before you deleted it.

The Recycle Bin and Trash only hold deleted files temporarily. On Windows, files usually stay for 30 days before they're gone for good. On Mac, the Trash empties automatically after 30 days. If you deleted the file more than a month ago, it's probably not there anymore.

If the file isn't in your Recycle Bin or Trash, and you need it back, you'll need to restore from a backup. Check whether your computer is set up to back up automatically — Windows has File History, and Mac has Time Machine. Both let you go back to a specific date and pull out files from that point.

Getting back a file you saved over by mistake

If you opened an Excel file, made changes, and saved it — but those changes were wrong — you can sometimes undo this. Open the file, then go to File > Info. Look for a section called Version History (in Excel online or newer versions of Excel on Windows and Mac).

Version History shows you older copies of the file that Excel saved automatically while you were working. Click on an earlier version to see what it looked like, then click Restore to go back to that point. This only works if you're using OneDrive, SharePoint, or Google Drive — files stored only on your computer don't have version history.

If you don't see Version History, your file is probably stored locally on your computer rather than in the cloud. In that case, check your backup software or ask your IT department whether they can restore an older copy from a backup.

Recovering files from OneDrive or Google Drive

If your Excel file is stored on OneDrive, go to OneDrive.com, find the file, right-click it, and choose Version History. You'll see a list of saved versions going back weeks or months. Click the version you want, then click Restore.

If you deleted the file entirely from OneDrive, go to the Recycle Bin folder on the left side of OneDrive.Com. Files stay there for 93 days. Click the file, then click Restore.

For Google Drive, right-click the file and choose Version History to see older copies. If you deleted the file, open the Trash folder, find it, right-click it, and choose Restore. Google Drive keeps deleted files for 30 days before they're permanently gone.

Using File History on Windows to go back further

If your Excel file was deleted weeks ago and you have a backup, Windows File History may have a copy. Go to Settings > System > Storage > Advanced Storage Options > Backups. Look for Backup Options and click See Advanced Options. Then click Restore Files from a Current Backup.

A window opens showing you folders as they existed on past dates. Navigate to the folder where your Excel file was, find the file, and click Restore. File History only works if you've been backing up to an external drive or network location — it won't help if you've never set up a backup.

If you're not sure whether File History is turned on, go to Settings > System > Storage > Advanced Storage Options > Backups and look for the toggle next to Automatically Back Up My Files. If it's off, File History hasn't been saving copies of your files.

Using Time Machine on Mac to restore older files

On Mac, Time Machine backs up your entire computer automatically if you've set it up. Click the Time Machine icon in the menu bar (top right of your screen) and choose Enter Time Machine. A timeline appears on the right side showing dates you can go back to.

Navigate to the date when your Excel file still existed, find the file in the folder, and click Restore. The file comes back to its original location. If you don't see the Time Machine icon in your menu bar, Time Machine isn't turned on — go to System Settings > General > Time Machine to check.

Time Machine only works if you've connected an external drive and turned it on. If you've never done that, you won't have backups to restore from.

What to do if nothing above works

If the file is gone and you don't have a backup, data recovery software may be able to find it — but this only works if the file was deleted recently and the space on your drive hasn't been overwritten yet. Programs like Recuva (Windows) or EaseUS Data Recovery Wizard (Windows and Mac) scan your drive for deleted files.

These tools are not may provide to work, especially if weeks have passed since the deletion. The longer you wait, the less likely recovery becomes. If the file is critical and recovery software doesn't find it, a professional data recovery service may be able to help — but this is expensive and only worth it for truly irreplaceable files.

Going forward, set up automatic backups so you don't face this situation again. Use File History on Windows, Time Machine on Mac, or store your files on OneDrive or Google Drive, where they're backed up automatically and you can recover older versions.

Frequently Asked Questions

Can I recover an Excel file if I never saved it?

Yes, if Excel crashed or you closed it without saving. Open Excel and look for the Document Recovery pane on the left, or go to File > Open > Recent and click Recover Unsaved Workbooks. These temporary files only stay for a few days, so check right away.

How long does Excel keep temporary files?

Excel keeps unsaved temporary files for about three to four days. After that, they're deleted. If you closed the file more than a few days ago without saving, recovery through Document Recovery probably won't work.

What's the difference between Recycle Bin and OneDrive trash?

Your computer's Recycle Bin holds deleted files for about 30 days. OneDrive trash holds them for 93 days. If your file is on OneDrive, check OneDrive trash first — you have more time to recover it there.

Will data recovery software definitely find my deleted file?

No. Data recovery software scans your drive for deleted files, but it only works if the space hasn't been overwritten yet. The longer you wait after deletion, the less likely recovery becomes. It's not may provide, especially for files deleted weeks ago.

Can I recover a file if I saved over it with the wrong version?

Yes, if the file is on OneDrive, SharePoint, or Google Drive. Go to File > Info > Version History to see older copies. If the file is only on your computer, check your backup software or ask your IT department about restoring from a backup.