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.
- Skill level:
- Moderately Easy
Other People Are Reading
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.
Enable Excel's Auto-Save Feature
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:\ Documents and Settings\<username>\Local Settings\Temp"
Temp files are prefaced with a tilde (~).
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.
Using Excel Auto-Save Recovery
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for