How to Recover an Excel Auto-Save File
Microsoft Excel is a spreadsheet application that is shipped with the Microsoft Office suite of products. Excel, as with other Microsoft Office programs, provides a feature that will automatically save the document in periodic increments. Also, if a computer shutdown is detected, Excel will auto-save the document in its current state. Make sure the auto-save feature is activated in Excel from the Tools menu, as this feature is not enabled by default in Excel.
Enable Excel's Auto-Save Feature
Open "Microsoft Excel."
Click "Tools" from the top navigation bar, and then select "Add-ins."
Click "Auto-Save" and edit any of the optional items. Click "OK." The auto-save feature is now enabled.
Using Excel Auto-Save Recovery
Open "Windows Explorer," and locate the Excel file's temp file to recover. This file will be saved in the same directory as the originally saved Excel files. In the event of a power failure or other issue, the file may not auto-save in the same location. Find the temp file, which will also be saved in one of the following directories, where "username" is the current user's access ID: "C:\Users\
Double-click on the file to recover. The file will open in Excel and automatically enable the Auto-Save Recovery feature. Click "Recover" to recover the document.
Save the temp file in Excel. The file has now been recovered.