How to recover an unsaved excel file

Written by michael joseph hall
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to recover an unsaved excel file
You won't lose all that work in Excel. (computer image by martini from

As you're running out the door, in a hurry, you realise you forgot to save the latest version of your work in Excel. Alternately, your computer may have crashed or run out of battery before you can save your most recent work. Before despairing, realise that these common problems are easily fixed in Excel 10. Microsoft Office includes the ability to recover both an unsaved workbook that's newly created as well as the most recent previous version of an Excel workbook.

Skill level:


  1. 1

    Open Excel and select the "File" menu.

  2. 2

    Choose "Recent" and then "Recover Unsaved Workbooks." The saved drafts folder opens on your desktop.

  3. 3

    Select the file you were working on and forgot to save. Select "File," and then "Save As."

  1. 1

    Open Excel and select the workbook in which you were working.

  2. 2

    Select "File," and then "Info."

  3. 3

    From the list of versions, click the one labelled "when I closed without saving."

  4. 4

    Click "Restore" from the business bar. This selection overwrites the previous version of the workbook to the last version autosaved.

Tips and warnings

  • Get yourself into the habit of saving your work every couple of minutes.
  • Never walk away from your computer without first saving your work.
  • Never open a new program or file before saving other documents that are already open.

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.