ThisCalculator

Everyday

Excel File Recovery: How to Recover Unsaved or Lost Files

Updated · Standard formula, shown below

Excel File Recovery: How to Recover Unsaved or Lost Files

Excel file recovery is the process of retrieving a spreadsheet that was lost due to an unsaved close, a crash, an accidental deletion, or a corrupted file. You can recover most Excel files using built-in features like AutoRecover, the Document Recovery pane, and the Recover Unsaved Workbooks option, with third-party tools as a backup for more severe cases. This guide explains the built-in methods first, then covers manual recovery steps, common failure points, and how to avoid losing work in the future.

How Excel’s AutoRecover Works

AutoRecover is Excel’s automatic backup system. By default, Excel saves a temporary copy of your open workbook every 10 minutes (the interval is adjustable in File > Options > Save). These copies are stored in a hidden folder on your computer. If Excel closes unexpectedly—due to a power outage, a system crash, or a program error—the next time you open Excel, the Document Recovery pane usually appears on the left side of the screen, listing any files that were recovered. You can click a listed file to open it, then use File > Save As to keep it permanently.

The AutoRecover file location is set in the same Options > Save menu. On Windows, it is typically C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\. On a Mac, the path is /Users/[YourUsername]/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Excel/. You can copy a file from that folder, rename it with an .xlsx extension, and open it in Excel.

Recovering Unsaved Workbooks (The Manual Method)

If you closed a workbook without saving and the Document Recovery pane did not appear, Excel still keeps a temporary copy for a limited time. To access it:

  1. Open Excel and go to File > Open.
  2. Click Recent at the top of the left-hand menu.
  3. Scroll to the very bottom of the Recent list and click Recover Unsaved Workbooks (on Windows; on Mac it is under File > Open > Recover Unsaved Workbooks).
  4. A folder opens containing any files Excel saved as unsaved backups. Select the one you need and click Open.
  5. Immediately save it with File > Save As to a normal location.

These unsaved files are stored in the same AutoRecover folder, but with a .xlsb or .xlsx extension and a name like “WorkbookName_Unsaved”. Excel purges these files after a few days, so recover them as soon as you notice the loss.

Recovering a Corrupted or Damaged Excel File

When a saved file becomes corrupted—often due to a sudden shutdown, a disk error, or a failed save—you can try Excel’s built-in repair tool:

  1. Open Excel, go to File > Open, and browse to the corrupted file.
  2. Click once on the file to select it, but instead of clicking Open, click the small dropdown arrow next to the Open button.
  3. Choose Open and Repair from the menu.
  4. In the dialog that appears, click Repair to attempt to fix the file. If that fails, click Extract Data to pull out the values and formulas without the formatting.

If the file is so damaged that Excel cannot open it at all, try opening it in a different program (like Google Sheets or LibreOffice Calc) and saving it as a new Excel file. This sometimes bypasses the corruption. Another option is to use a file recovery tool that scans the disk for remnants of the original file, but these tools are less reliable and often require a paid license for full recovery.

Recovering a Deleted Excel File (From Recycle Bin or Backup)

If you accidentally deleted an Excel file, the first place to check is the Recycle Bin (Windows) or Trash (Mac). Right-click the file and choose Restore. If the file is not there, it may have been permanently deleted or the Recycle Bin may have been emptied. In that case, check these sources:

  • File History (Windows): If you turned on File History in Windows settings, right-click the folder that contained the file, select Properties > Previous Versions, and look for a version from before the deletion.
  • Time Machine (Mac): If Time Machine is enabled, open the folder in Finder, enter Time Machine, and scroll back to a date when the file existed.
  • OneDrive or SharePoint: If the file was stored in the cloud, open the online version, go to the file’s history, and restore an earlier version. Deleted files stay in the cloud recycle bin for 30 days (longer with admin settings).
  • Email or messaging: If you ever sent the file as an attachment, download it from your sent folder.

Why Excel Files Get Lost in the First Place

Most Excel file loss falls into one of five categories. Understanding the cause helps you choose the right recovery method:

  • Unsaved close: You clicked “Don’t Save” or closed the file without saving. The AutoRecover copy is your best bet.
  • Crash or power failure: Excel or the computer stopped working while the file was open. The Document Recovery pane should appear on restart.
  • Accidental deletion: The file was deleted from the folder. Check the Recycle Bin first.
  • Corruption: The file is damaged and won’t open normally. Use Open and Repair.
  • Overwrite: You saved over the original with changes you didn’t want. Check Previous Versions or cloud version history.

A common misconception is that Excel saves your file continuously. It does not. AutoRecover only creates a backup if you have made changes and the file has been open for at least the interval you set (default 10 minutes). If you close a file within seconds of making a change, that change may not be in the AutoRecover copy.

How to Set Up AutoRecover for Maximum Safety

You can reduce the risk of losing work by adjusting Excel’s default settings:

  1. Go to File > Options > Save (Windows) or Excel > Preferences > Save (Mac).
  2. Check the box for Save AutoRecover information every and set the minutes to a low number like 1 or 2. This increases the frequency of backups but may slow down Excel slightly on very large files.
  3. Check the box for Keep the last autosaved version if I close without saving. This preserves the most recent AutoRecover copy even if you intentionally close without saving.
  4. Set the AutoRecover file location to a folder you can easily find, such as a dedicated folder on your desktop.
  5. For files stored in OneDrive or SharePoint, make sure AutoSave is turned on (the toggle in the top-left corner of the Excel window). AutoSave saves every few seconds directly to the cloud, making local recovery almost unnecessary.

Third-Party Recovery Tools: What They Can and Can’t Do

When built-in methods fail, some users turn to third-party file recovery software. These tools scan the hard drive for deleted file fragments and attempt to reconstruct them. They work best on files that were recently deleted and have not been overwritten by new data. They cannot recover files that were never saved to disk, and they rarely recover a corrupted file that Excel cannot open. Free versions often allow you to scan and preview files, but you must pay to actually recover them. There is no guarantee of success, so always try Excel’s built-in options first.

Preventing Future Excel File Loss

The best recovery method is the one you never need. Adopt these habits to keep your work safe:

  • Save frequently: Press Ctrl+S (Windows) or Cmd+S (Mac) every few minutes, or turn on AutoSave for cloud files.
  • Use version history: If you save to OneDrive, SharePoint, or Google Drive, you can access previous versions of the file from the web interface or the app.
  • Keep backups: Copy important files to an external drive, a USB stick, or a cloud service on a regular schedule.
  • Close files properly: Use File > Close rather than closing the window with the X, and always respond to the “Save changes?” prompt deliberately.
  • Test your recovery: Once a month, try the Recover Unsaved Workbooks feature to confirm it works on your system.

Frequently Asked Questions

Can I recover an Excel file if I didn’t save it and AutoRecover was off?
No. If AutoRecover was disabled and you never saved the file, there is no copy on disk. The only hope is a third-party tool that scans memory or disk for fragments, but that is extremely unreliable. Always keep AutoRecover enabled.

How long does Excel keep unsaved workbooks?
Excel stores unsaved files in the AutoRecover folder for up to 4 days (in most versions). After that, they are automatically deleted. The Recover Unsaved Workbooks dialog shows files from the last few days only.

Why doesn’t the Document Recovery pane appear after a crash?
It may not appear if Excel closed cleanly (e.g., you chose “Don’t Save”), if you disabled AutoRecover, or if the crash happened before the first AutoRecover interval elapsed. You can still try File > Open > Recent > Recover Unsaved Workbooks manually.

What is the difference between AutoRecover and AutoSave?
AutoRecover saves a local backup copy of an open file at set intervals. AutoSave saves your changes continuously to the cloud (OneDrive/SharePoint) as you type. AutoSave only works for files stored in the cloud; AutoRecover works for all files.

Can I recover a file that was overwritten by a new version?
If you saved over a file and want the old version back, check File > Info > Version History (for cloud files) or right-click the file in File Explorer > Properties > Previous Versions (for local files with File History enabled). If neither is available, the old version is likely gone.

Does Excel save a temporary file for every open workbook?
Excel creates a temporary file for each open workbook, but it is not a full backup—it is a working copy that may be deleted when the file closes normally. The temporary file becomes useful only when Excel crashes, and it is the source for the Document Recovery pane.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.