top of page

You are learning The Excel Interface

How can I recover unsaved data or a workbook crash?

There are a couple of ways you might be able to recover unsaved data or a workbook after a crash in Excel:

1. Use Excel's AutoRecover Feature:

- This is the most likely solution for recovering unsaved work. Excel automatically saves your work at regular intervals in temporary files called AutoRecover files.
- Steps to recover:
1. Open Excel.
2. Depending on your Excel version, you might see a Document Recovery pane on the left side listing unsaved workbooks. If not, navigate to:
- File tab > Info
- Under Manage Workbooks (or Manage Document in older versions) click Recover Unsaved Workbooks.
3. A window will appear showing recently recovered files. Identify the file you lost based on the date and time.
4. Select the file and click Open.
5. Excel will display the recovered data. You'll likely see a yellow bar at the top prompting you to save the file with a new name.

2. Check the AutoSave Location:

- If the Document Recovery pane doesn't show your file, you can try manually accessing the AutoSave location on your computer.
- Steps to find the location:
1. Open Excel.
2. Go to File > Options.
3. In the Options window, click Save.
4. Look for the setting labeled AutoRecover file location. This path indicates where Excel saves temporary files.
5. Open this location using File Explorer (Windows) or Finder (Mac).
6. Look for files with names similar to your workbook and an ".asd" extension (AutoSave data). Note: These files might be cryptic and difficult to identify by content alone.
7. If you find a relevant file, try copying it to a safe location and changing the extension from ".asd" to ".xlsx" (or the appropriate format for your Excel version). You might then be able to open it in Excel.

Important Notes:

- The effectiveness of these methods depends on various factors like how frequently Excel autosaves and if your computer shut down unexpectedly. There's no guarantee you'll always recover your work.
- Having a habit of saving your work frequently is crucial to avoid data loss. Consider enabling Excel's autosave feature at shorter intervals for better protection.
- If these methods fail, and you haven't recently saved your work, you might have lost the data permanently.

bottom of page