How to Recover an Excel Auto-Save File

Written by tammy clevenger
  • Share
  • Tweet
  • Share
  • Email

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


    Enable Excel's Auto-Save Feature

  1. 1

    Open "Microsoft Excel."

  2. 2

    Click "Tools" from the top navigation bar, and then select "Add-ins."

  3. 3

    Click "Auto-Save" and edit any of the optional items. Click "OK." The auto-save feature is now enabled.

    Using Excel Auto-Save Recovery

  1. 1

    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 (~).

  2. 2

    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.

  3. 3

    Save the temp file in Excel. The file has now been recovered.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.