How to recover a lost workbook or a lost version of a workbook in Excel 2007 and in Excel 2003

Article translations Article translations
Article ID: 827298 - View products that this article applies to.
Expand all | Collapse all

On This Page

For a Microsoft Excel 2002 version of this article, see 324521.

SUMMARY

If you delete, lose, save over, or do not save a Microsoft Office Excel 2007 or Microsoft Office Excel 2003 workbook, you may be able to recover it. Excel has an AutoRecover feature that automatically saves workbooks when you have an accidental loss of power or similar problems.

MORE INFORMATION

For additional information about the AutoRecover feature, click the following article number to view the article in the Microsoft Knowledge Base:
289273 Description of the AutoRecover functions in Excel 2002 and in Excel 2003
To see if the missing workbook exists, search for .xls files on your computer. To do this, follow the steps for your operating system.

Windows XP

  1. Click Start, and then click Search.
  2. In the Search Results window, click All files and folders.
  3. In the All or part of the file name dialog box, type:
    *.xls
    .
  4. Under Type of file, expand More advanced options, and then click All Files and Folders.
  5. Click to select the Search system folders and the Search hidden files and folders check boxes, and then click Search.

Windows 2000

  1. Click Start, click Search, and then click Find Files or Folders.
  2. In the Search for files or folders named dialog box, type:
    *.xls
  3. Make sure that your primary hard disk, typically disk C, appears in the Look in dialog box, click to select the Include subfolders check box, and then click Search Now.
After the search, follow these steps:
  1. Double-click a file in the Results list to open it in Excel and see if it is the version that you are missing.

    Note If none of the .xls files in the Results list is the version that you are missing, go to the next step.
  2. Repeat the search, but this time type:
    *.xar
  3. Double-click a file in the Results list to open it in Excel and see if it is the version that you are missing.

    Note If none of the .xar files in the Results list is the version that you are missing, go to the next step.
  4. On the desktop, double-click Recycle Bin to see if the workbook that you want is there. If the missing workbook is not located in any of these areas, the workbook is lost. To recover it, you must re-create it.

Properties

Article ID: 827298 - Last Review: September 19, 2011 - Revision: 4.0
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbhowto KB827298

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com