Microsoft Excel 2007 with Example

3 Basics

3.6 Workbook: AutoRecover

File that was never saved    |   Saved at least once    |   Versions    |   Options

Excel periodically saves a copy of your Excel file. Learn how to recover a file that was never saved and how to recover a file that has been saved at least once.

If Excel crashes, it displays the Document Recovery Pane, the first time you open Excel again. This is a quick way to recover the last autosaved file.

Document Recovery

File that was never saved

If you've never saved a file and you accidentally click Don't Save below when you close Excel (or Excel crashes), execute the following steps to recover the last autosaved file.

Don't Save Book1

Note: Excel tells you that if a recent copy will be available.

1. On the File tab, click Info.

2. Click Manage Versions, Recover Unsaved Workbooks.

Recover Unsaved Workbooks

3. Click the last autosaved file.

Saved at least once

If you've saved a file at least once and you accidentally click Don't Save below when you close Excel (or Excel crashes), execute the following steps to recover the last autosaved file.

Don't Save grades.xlsx

Note: Excel tells you if a recent copy will be available.

1. Open the file.

2. On the File tab, click Info.

3. Under Versions, click the last autosaved file.

Closed Without Saving

Versions

When you are working on an Excel file, Excel saves all previous autosaved files under Versions.

1. At any time, you can go back to a previous version of your Excel file.

Versions

Note: Excel deletes all previous autosaved files when you close the Excel file.

Options

To change the AutoRecover options, execute the following steps.

1. On the File tab, click Options, Save.

Options

Note: you can save AutoRecover information every x minutes, change the AutoRecover file location, etc.