Losing an Excel file - a crash before you saved, a wrong click that deleted it, an overwrite - feels like hours of work gone. In most cases it is not. Excel keeps safety nets, and deleted files usually linger on the drive. The trick is to match the right method to what actually happened. Here is how, case by case.
First, what happened?
There are three different situations, and each has a different fix:
- Unsaved - Excel crashed or you closed without saving. Use AutoRecover.
- Deleted - you removed the .xlsx file itself. Use the Recycle Bin or recovery software.
- Overwritten - you saved over a good version with a bad one. Use version history.
Pick the one that matches yours below.
Case 1 - Recover an unsaved Excel file
This is the most common, and the most recoverable. Excel's AutoRecover quietly saves copies of your work at a fixed interval, 10 minutes by default. That default is also the size of your worst case: whatever you typed since the last automatic save is not in the copy, so a crash costs you between zero and ten minutes of work. The interval is adjustable in File → Options → Save, where the accepted range runs from 1 to 120 minutes, and setting it to 1 or 2 costs nothing noticeable on a normal workbook. Open Excel, go to File → Open, and click Recover Unsaved Workbooks at the bottom of the recent files list. That opens the folder of temporary copies, where your file is likely waiting. Open it and save it properly this time. The same trick works in Word - our guide to a lost Word document covers it in detail.
Case 2 - Recover a deleted Excel file
If you deleted the file itself, first check the Recycle Bin (Windows) or Trash (Mac) and restore it - that solves most cases instantly. If the bin was emptied, the data usually still exists on the drive until something overwrites it. So stop saving anything to that drive and run recovery software, which scans for deleted .xlsx files and rebuilds them - the same method as our full guide to recover deleted files. Always recover to a different drive than the one you are scanning.
One detail decides how well this works. Since Excel 2007 an .xlsx is not a single binary blob but a ZIP container holding XML files, so it begins with the same 4-byte signature as any ZIP archive: 50 4B 03 04, the ASCII characters PK followed by two control bytes. Carving tools key on that signature, which is why a recovered spreadsheet sometimes arrives named as a .zip: renaming the extension back to .xlsx is occasionally all that stands between you and an openable file. The older .xls format is a different container entirely and carries a different signature, so tell your recovery tool which one you are looking for.
Scan for your deleted Excel file with EaseUS Data Recovery
Case 3 - Recover an overwritten Excel file
If you saved over a good version, the file still exists - you just need an earlier copy. If it lives in OneDrive, SharePoint or Teams, right-click it and choose Version History to roll back. On Windows, you can also right-click the file → Properties → Previous Versions if File History or a restore point is set up. Cloud version history is the most reliable undo for an overwrite - see our dedicated guide on how to recover overwritten files if no version is listed.
How to avoid this next time
Two settings turn most of these disasters into non-events. Turn on AutoSave (for files in OneDrive) and confirm AutoRecover is enabled in File → Options → Save. Keep important workbooks in OneDrive so you get automatic version history. With those on, a crash or a bad save becomes a quick rollback instead of lost work.
The bottom line
An unsaved Excel file is almost always recoverable through AutoRecover; a deleted one through the Recycle Bin or recovery software; an overwritten one through version history. Work out which case you are in, act before the drive gets written over, and most of the time you will get your spreadsheet back. Then turn on AutoSave so it cannot happen the same way twice.
Recover your deleted files → EaseUS
Free scan · deleted, formatted & lost files · Windows & Mac
