Select the product you need help with

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

Article ID: 827298 - View products that this article applies to.

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.

Back to the top | Give Feedback

MORE INFORMATION

For additional information about the AutoRecover feature, click the following article number to view the article in the Microsoft Knowledge Base:

289273

(http://support.microsoft.com/kb/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

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

Windows 2000

Click Start, click Search, and then click Find Files or Folders.
In the Search for files or folders named dialog box, type:
*.xls
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:

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.
Repeat the search, but this time type:
*.xar
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.
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.