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