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