Software & Apps MS Office How to Recover an Excel File Make use of the autorecover and document recovery features by Scott Orgera Writer Scott Orgera is a former writer who covering tech since 2007. He has 25+ years experience as a programmer and QA leader, and holds several Microsoft certifications. our editorial process Facebook Twitter Scott Orgera Updated on January 24, 2020 Vasko/E+/Getty Images MS Office Excel Word Powerpoint Outlook Tweet Share Email There aren’t many feelings worse than working on a spreadsheet for a while, only to lose your changes because the application crashed or your entire computer froze up and your Microsoft Excel document was not saved. Thankfully, Excel (and all of Microsoft Office) offers a fail safe that allows you to retrieve some or all of that lost work via its recovery feature. Microsoft 365 automatically stores files in the cloud by default, typically on OneDrive or SharePoint, unless you specify otherwise. This tutorial is intended for users attempting to recover a file stored locally on their hard drive in Excel for Microsoft 365, Excel 2019, Excel 2016, and Excel 2013. How to Enable AutoRecover in Excel To retrieve lost files that may have been saved on your computer, you first need to make sure the AutoRecover feature is enabled. If you’ve already lost a file and are trying to recover it, skip to the next section for now. If the file in question is not shown in the Document Recovery screen, then it probably cannot be recovered. That said, you’ll still want to enable AutoRecover to avoid this situation in the future. It’s also good practice to manually save your files often while working on them. Enable AutoRecover in Excel for macOS Launch Excel and open any workbook. Click Excel > Preferences. The Excel Preferences dialog should appear, overlaying the main interface. Click Save, found in the Sharing and Privacy section. Excel’s Save options will now be visible, each accompanied by a check box. Select Save AutoRecover info in every xx minutes if no check mark is present. You can also specify how often you’d like AutoRecover to save your active documents by modifying the number of minutes in the aforementioned option. The default setting in most versions of Excel is 10 minutes. Close the Preferences interface to return to your Excel session. Enable AutoRecover in Excel for Windows Launch Excel and open any workbook. Select File > Options. The Excel Options interface should now be displayed, overlaying your workbook. Select Save, found in the left menu pane. Excel’s Save options will now be visible, most accompanied by a check box. Select Save AutoRecover information every xx minutes if no check mark is present. You can also specify how often you’d like AutoRecover to save your active documents by modifying the number of minutes in the aforementioned option. The default setting in most versions of Excel is 10 minutes. Below this option is another called "Keep the last AutoRecovered version if I close without saving." Enabled by default, this ensures that the version of your workbook most recently saved by the AutoRecover feature will be stored anytime you close Excel without manually saving it. It's recommended you leave this option active. Select OK to return to your Excel session. How to Recover an Unsaved Excel File As long as AutoRecover is enabled the Document Recovery interface will automatically appear the next time you launch Excel. This interface contains a section labeled Available Files, listing all autosaved workbooks along with the document name and the date/time it was last saved. To recover any of the files listed, select the arrow accompanying its details, then select Open. To remove AutoRecovered files that are no longer needed, select the arrow, then select Delete. As mentioned at the outset, if the file you're looking for is not in this list, chances are it was never saved and may be permanently lost.