How to link to data in a file that is damaged in Excel 2000 (214253)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q214253
For a Microsoft Excel 98 and earlier version of this article, see 147216.

SUMMARY

In Microsoft Excel, you may be able to extract the values from a damaged file by using external references to link to the file.

MORE INFORMATION

To extract the values from a damaged file, use either of the following methods.

Method 1

  1. On the File menu, click Open. Then, browse from the current folder to the folder that contains the damaged file, and click Cancel.
  2. Click New on the File menu; click Workbook, and then click OK.
  3. Type =File Name!A1 in cell A1 of the new workbook, where File Name is the name of the damaged workbook. If the Select Sheet dialog box appears, select the appropriate sheet, and click OK.
  4. Select cell A1, and on the Edit menu, click Copy. Then, select an area that is approximately the same size as the range of cells that contain data in the damaged file, and then click Paste on the Edit menu.
  5. With this range of cells still selected, click Copy on the Edit menu.
  6. On the Edit menu, click Paste Special. Select Values and click OK.
This step removes the links to the damaged file and leaves only the data.

Method 2

  1. Click New on the File menu; click Workbook, and then click OK.
  2. Create a second new workbook by repeating step 1.
  3. In the first workbook, select cell A1. Then, click Copy on the Edit menu.
  4. Switch to the second workbook and select cell A1. Then, click Paste Special on the Edit menu and click Paste Link.
  5. Select cell A1 and remove the dollar signs from the formula.

    For example, if the formula bar displays the text

    =[Book13]Sheet1!$A$1

    remove the dollar signs. The formula bar should display the following text:

    =[Book13]Sheet1!A1

  6. Select cell A1 and click Copy on the Edit menu.
  7. Select an area that is approximately the same size as the range of the cells that contain data in the damaged file (for example, select A1:H100), and then click Paste on the Edit menu.
  8. With this cell range selected, click Links on the Edit menu.
  9. In the Links dialog box, select the file name of the first workbook, and click Change Source. When the Change Links dialog box appears, select the damaged file and click OK. If the Select Sheet dialog box appears, click the appropriate sheet and click OK.
  10. In the Links dialog box, click OK.
  11. With the cell range still selected, click Copy on the Edit menu.
  12. On the Edit menu, click Paste Special. Select Values, and then click OK.
This removes the links to the damaged file and leaves only the data.

REFERENCES

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

179871 Methods for recovering data from damaged Excel 2000 workbooks

Modification Type:MinorLast Reviewed:10/28/2004
Keywords:kbcorrupt kbQuery kbxlslink kbnewfile kberrmsg kbhowto KB214253
©2004 Microsoft Corporation. All rights reserved.