Microsoft KB Archive/147216

= Linking to data in a damaged file (5.0 and later) =

Article ID: 147216

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q147216





For a Microsoft Excel 2000 version of this article, see 214253.



SUMMARY
In Microsoft Excel version 5.0 and later versions, you can 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 one of the following methods.

Method 1

 * 1) On the File menu, click Open.
 * 2) Browse from the current folder to the folder that contains the damaged file, and then click Cancel.
 * 3) If you are using Microsoft Excel 7.0, Microsoft Excel 97, or Microsoft Excel 98 Macintosh Edition, click New on the File menu, click Workbook, and then click OK.

If you are using Microsoft Excel 5.0, click New on the File menu, and then click OK. If the New dialog box appears, click Workbook, and then click OK.
 * 1) Type "=< >!A1" (without the quotation marks) in cell A1 of the new workbook, where < > is the name of the damaged workbook. If the Select Sheet dialog box appears, select the appropriate sheet, and then click OK.
 * 2) Select cell A1, and then click Copy on the Edit menu.
 * 3) 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.
 * 4) With this range of cells still selected, click Copy on the Edit menu.
 * 5) On the Edit menu, click Paste Special, click Values, and then click OK.

This step removes the links to the damaged file and leaves only the data.

Method 2
 If you are using Microsoft Excel 7.0, Microsoft Excel 97, or Microsoft Excel 98 Macintosh Edition, click New on the File menu, click Workbook, and then click OK.

If you are using Microsoft Excel 5.0, click New on the File menu, and then click OK. Create a second new workbook by repeating step 1. In the first workbook, select cell A1. On the Edit menu, click Copy. Click the second workbook and select cell A1. oOn the Edit menu, click Paste Special, and then click Paste Link.</li> Select cell A1, and then remove the dollar signs from the formula.

For example, if the formula bar displays the following text, remove the dollar signs:

=[Book13]Sheet1!$A$1

The formula bar should display the following text:

=[Book13]Sheet1!A1

</li> Select cell A1, and then click Copy on the Edit menu.</li> 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.</li> On the Edit menu, click Links.</li> In the Links dialog box, select the file name of the first workbook, and then click Change Source. When the Change Links dialog box appears, select the damaged file, and then click OK. If the Select Sheet dialog box appears, click the appropriate sheet, and then click OK.</li> In the Links dialog box, click OK.</li> With the cell range still selected, click Copy on the Edit menu.</li> On the Edit menu, click Paste Special, click Values, and then click OK.</li></ol>

This removes the links to the damaged file and leaves only the data.

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

142117 XL: Summary of methods to recover data from corrupted files

<div class="references_section">