If a workbook you were working on was closed without being saved, either by a program crashing or just by accident, you may be able to recover it. Excel periodically saves a copy of your Excel file. By default, this setting is every 10 minutes, but you can easily change this setting.
Recover a Workbook
If Excel crashes, it will display the Document Recovery Pane the first time you open Excel again
- Restart Microsoft Excel.
If an unsaved workbook can be recovered, the Recovered header will appear on the left.
- Click Recover unsaved workbooks.
The Recovery pane appears, listing all recovered workbooks that were found.
- Select the workbook from the Document Recovery pane.
The last AutoSaved version of that workbook opens.
- Click Close.
If the workbook that you were hoping to recover doesn’t appear, it’s probably because the AutoRecovery settings didn’t catch it. We can change those settings so that it’s a bit more diligent about auto-saving your workbooks.
- Click the File tab.
- Click Options.
- Click Save.
The AutoRecovery settings are here. Make sure that the proper checkboxes are checked.
- Make sure the Save AutoRecover information every checkbox is checked and adjust the time interval.
You can’t specify the interval if the checkbox is not selected.
- Click OK.
FREE Quick ReferenceClick to Download
Free to distribute with our compliments; we hope you will consider our paid training.
- How to Make an Excel Spreadsheet
- Open an Excel Workbook
- How to Save in Excel