How to Recover Lost Excel 2007 Data From an Unsaved Worksheet


Microsoft Excel 2007 includes an AutoRecover option that saves early versions of your worksheet. If your computer unexpectedly shuts down before you could save your current data, then the Document Recovery feature may display your worksheet saved in one to three files. Although the most recent data may be lost, your worksheet will retain its format and data up to the time of the last save.

Activate the AutoRecover Option

  • Open the worksheet.

  • Click the "Microsoft Office" button on the top left of the screen. A drop-down menu opens.

  • Click the "Excel Options" button at the bottom of this window. A dialog window for "Excel Options" opens.

  • Click on the "Save" command in the left pane. A dialog window for "Save Workbooks" appears.

  • Check the "Save AutoRecover Information Every [ ] Minutes." Select the number of minutes.

  • Click the "OK" button.

Use the Document Recovery Pane

  • Open the worksheet. The Document Recovery task pane opens to the left of your document. The pane may display one to three versions of your Excel worksheet.

  • Right-click on one of the file versions. A list will display three commands: Open, Save As and Delete. The Open command lets you review this recovered worksheet. The Save As command will rename or start a new version of the saved worksheet. The Delete command will delete the worksheet.

  • Click on the "Open" or "Save As" for the version you wish to revise or save.

  • Save this worksheet.

Tips & Warnings

  • Check the "AutoRecover" option before you work on a worksheet.
  • If you deleted the worksheet, no recovered copy will show in the Document Recovery pane.

Related Searches


  • Photo Credit Jason Reed/Photodisc/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!