Excel keeps recent versions of unsaved work, and you can usually get them back

If you closed a spreadsheet without saving, or deleted it by mistake, Excel has built-in recovery tools that work without any setup on your part. The method depends on whether you saved the file at all, how long ago you closed it, and which version of Excel you use. Most people can recover their work in under five minutes.

The fastest route is usually the "Recent Documents" list or the AutoRecover folder, both of which hold temporary copies Excel creates automatically. If those don't have what you need, your operating system's trash or recycle bin may still hold the file itself. This guide covers the real steps in the order that works best.

Key Takeaways

  • Excel automatically saves temporary copies every 10 minutes by default, and you can open these from the File menu without needing to find them manually.
  • If you closed the file without saving, look in Recent Documents first — Excel keeps a list of files you've opened even if you didn't save your changes.
  • Deleted files sit in your computer's Recycle Bin (Windows) or Trash (Mac) for weeks or months before being permanently removed, so check there before trying other methods.
  • The AutoRecover folder holds temporary backup files that Excel creates during your work session, and you can browse it directly if the automatic recovery dialog doesn't appear.
  • If none of these methods work, your file may be gone permanently, but checking all four routes takes only a few minutes and costs nothing.

Recover an unsaved file using Recent Documents

When you close a spreadsheet without saving your changes, Excel remembers that you had it open. Open Excel and go to File > Recent. Look for the file name with a note that says "unsaved" or shows a date and time. Click it to open the version with your unsaved changes.

This works because Excel keeps a record of files you've opened in the last few weeks, separate from whether you saved them. The unsaved version is stored temporarily and will disappear after about four weeks of not opening that file, or if you restart your computer and don't open Excel again before the temporary file expires.

If you don't see the file in Recent Documents, move to the AutoRecover folder method below. Recent Documents only shows files you've opened before — if this was a brand new spreadsheet you never saved, it won't appear here.

Find temporary copies in the AutoRecover folder

Excel creates a backup copy of your work every 10 minutes while you have a file open. These temporary files sit in a hidden folder on your computer. If Excel crashed or you force-closed it, you may see a recovery dialog the next time you open Excel — click Recover to restore your work.

If that dialog doesn't appear, you can browse the AutoRecover folder directly. On Windows, go to File > Options > Save, and look for the line that says "AutoRecover file location." Copy that path, open File Explorer, paste it into the address bar, and press Enter. You'll see a list of .xlsx files with long names — these are your temporary backups. Open the one with the most recent date and time.

On Mac, go to Excel > Preferences > Save, and find the AutoRecover location. Open Finder, press Command+Shift+G, paste the path, and click Go. The temporary files will be there with timestamps. Open the newest one.

These temporary files expire after four days of not opening Excel, so this method only works if you're recovering work from the last few days. If your file is older than that, check your Recycle Bin or Trash instead.

Check your Recycle Bin or Trash for deleted files

If you deleted the file itself, it doesn't disappear when ready — it moves to your Recycle Bin (Windows) or Trash (Mac) first. On Windows, open File Explorer and click Recycle Bin in the left sidebar. Look for your spreadsheet by name. Right-click it and select Restore. The file will go back to wherever it was before you deleted it.

On Mac, click the Trash icon in your dock (usually in the bottom right corner). Look for your file, right-click it, and select Put Back. It will return to its original location.

Files stay in Recycle Bin or Trash for weeks or months depending on your settings, so this method usually works unless you've already emptied the bin. Once you empty it, the file is much harder to recover and requires specialized data recovery software.

Use OneDrive or Google Drive version history if you use cloud storage

If your spreadsheet was saved to OneDrive (Microsoft's cloud storage), you can recover older versions directly from the web. Go to OneDrive.com, find the file, right-click it, and select Version history. You'll see a list of every save with timestamps. Click the version you want and select Restore.

Google Drive works the same way. Open the file in Google Sheets, click File > Version history > See all versions. Click the version you want, then click Restore this version at the top.

Cloud storage keeps version history for 30 days by default, though some accounts keep it longer. This method only works if the file was actually saved to the cloud — if it was only on your computer, you'll need to use the AutoRecover folder or Recycle Bin instead.

Prevent this from happening again with AutoSave and AutoRecover settings

Excel's AutoRecover feature is on by default, but you can make it save more often. Go to File > Options > Save (Windows) or Excel > Preferences > Save (Mac). Look for "Save AutoRecover information every X minutes" and change the number to something shorter — 5 minutes instead of 10, for example. The shorter the interval, the less work you lose if something goes wrong.

If you use OneDrive or SharePoint, turn on AutoSave instead. This saves your changes continuously as you work, so you never have to remember to press Ctrl+S. Go to File > AutoSave and toggle it on. AutoSave only works for files stored in the cloud, not files on your local computer.

You can also change how long Excel keeps temporary files. In the same Save options menu, look for "Keep the last AutoRecovered version if I close without saving" and make sure it's checked. This ensures that even if you close without saving, Excel will hold onto a backup for you.

What to do if none of these methods find your file

If you've checked Recent Documents, AutoRecover, Recycle Bin, and version history and still can't find your work, the file is likely gone. This usually happens when you permanently delete a file and empty the trash, or when your computer crashes and AutoRecover files expire before you can recover them.

At this point, you have two options. You can try third-party data recovery software like EaseUS Data Recovery Wizard or Recuva, which scan your hard drive for deleted files. These tools sometimes work, but they're not may provide — the longer your computer has been in use since the deletion, the less likely recovery becomes. They also cost money and require some technical comfort.

The other option is to accept the loss and rebuild the spreadsheet from scratch or from a backup you made earlier. This is faster than waiting for recovery software to scan your drive, and it's the most reliable way forward.

Frequently Asked Questions

How long does Excel keep AutoRecover files?

Excel keeps AutoRecover temporary files for four days after you last opened the file. After that, they're deleted automatically. If you need to recover work older than four days, check your Recycle Bin or cloud storage version history instead.

Can I recover a file if I never saved it at all?

Yes, if you opened it in Excel at least once. Check Recent Documents first — Excel tracks files you've opened even if you never saved them. If it's not there, check the AutoRecover folder. If you created a brand new spreadsheet, typed in it, and closed it without ever saving, AutoRecover may still have a temporary copy from the last 10 minutes you had it open.

What's the difference between AutoRecover and AutoSave?

AutoRecover creates temporary backup copies every 10 minutes and only helps if something goes wrong — you have to manually recover them. AutoSave saves your changes continuously as you work, so there's nothing to recover — your file is always up to date. AutoSave only works for files stored in OneDrive or SharePoint, not local files.

If I restore a file from Recycle Bin, will my changes still be there?

Yes. Restoring from Recycle Bin brings back the exact file as it was when you deleted it, with all your changes intact. The file goes back to the folder it was in before you deleted it.

Does Excel keep version history automatically, or do I have to turn it on?

AutoRecover is on by default, but version history in OneDrive or Google Drive requires that your file be saved to the cloud. If your file is only on your computer, you won't have version history — only AutoRecover temporary files. To get version history, save your file to OneDrive or Google Drive instead of your local hard drive.