Table of Contents

AutoRecover

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

Recover a 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 if a recent copy will be available.

1. On the File tab click Info.

2. Click Manage Workbook 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 Excel file!

2. On the File tab click Info.

3. Under Manage Workbook click the last autosaved file.

Closed Without Saving

Versions

When you are working on an Excel file Excel saves all previous autosaved files under Manage Workbook.

1. On the File tab click Info.

2. 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.

AutoRecover 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.

Leave A Comment

Excel meets AI – Boost your productivity like never before!

At Formulas HQ, we’ve harnessed the brilliance of AI to turbocharge your Spreadsheet mastery. Say goodbye to the days of grappling with complex formulas, VBA code, and scripts. We’re here to make your work smarter, not harder.

Related Articles

The Latest on Formulas HQ Blog