When Excel Crashes, Does It Recover Your Work?

When Excel crashes unexpectedly, the first thing everyone wants to know is whether their unsaved work is gone forever.

Contents:

1. Quick Answer

2. How AutoRecover Works

3. Where to Find Recovered Files

4. What to Do If the Recovered File Doesn't Appear

5. How to Make Sure AutoRecover Is Turned On

Quick Answer

Yes, Excel will usually recover your unsaved work automatically using a built-in feature called AutoRecover. When you reopen Excel after a crash, it shows a Document Recovery pane on the left side of the screen with any recoverable versions of your file. The catch: AutoRecover only saves a temporary backup every 10 minutes by default, so you may lose the last few minutes of changes.

How AutoRecover Works

Excel quietly saves a temporary copy of your open workbook in the background at a set interval (10 minutes by default). These are not the same as your actual saved file. They are hidden backups stored in a system folder, and their only job is to give Excel something to restore from if it crashes before you hit Save.

When Excel restarts after a crash, it reads those temporary files and presents them to you. You pick the version you want, save it properly, and you're back in business.

One important thing: AutoRecover is not a substitute for saving. If you made major changes in the last 10 minutes before a crash, those changes may not be in the recovered file.

Where to Find Recovered Files

Normally, the Document Recovery pane appears automatically on the left side of the screen the next time you open Excel. Each recoverable file shows a timestamp so you can pick the most recent version.

If the pane doesn't appear automatically, you can go looking for the recovery files manually. The default AutoRecover file location is:

C:\Users\<YourUsername>\AppData\Roaming\Microsoft\Excel\

The files there have an .xlsb or .xls extension and a name that includes the original filename. You can open them directly from File Explorer. Just open the file, then immediately do a Save As to save it as a proper .xlsx in a location you control.

What to Do If the Recovered File Doesn't Appear

If the Document Recovery pane is missing and the AppData folder is empty, a few things may have happened. Excel may have already cleaned up the temp files (it does this once you close the recovery pane without saving), or the crash may have occurred before AutoRecover had a chance to save a backup.

In that case, check one more place. In Excel, go to File > Info > Manage Workbook and look for an option that says "Recover Unsaved Workbooks." This opens a separate folder where Excel keeps drafts of files that were never saved at all (new workbooks that never got a proper Save).

If nothing turns up there either, the work is most likely gone.

How to Make Sure AutoRecover Is Turned On

It's worth checking your AutoRecover settings now, before the next crash. Go to File > Options > Save. You'll see two key settings.

The first is "Save AutoRecover information every X minutes." Dropping this from 10 minutes to something like 2 or 3 minutes means you'll lose much less work in a crash.

The second is "Keep the last AutoRecovered version if I close without saving." Make sure this checkbox is ticked. It's the setting that covers you when you accidentally click "Don't Save" on exit.

While you're thinking about protecting your work, it's also worth knowing that Excel files and CSV files are stored differently, which affects what data is preserved. The Are Excel Files CSV Files? post covers that distinction well.