Microsoft KB Archive/45557

= Handling Corrupted Excel Files by Saving in the SYLK Format =

PSS ID Number: 45557

Article Last Modified on 8/19/2003

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows
 * Microsoft Excel for Windows 95 7.0
 * Microsoft Excel for Windows 5.0
 * Microsoft Excel 98 Macintosh Edition

-



This article was previously published under Q45557



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

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



SUMMARY
If you suspect that you have a corrupted Microsoft Excel file and you are able to open the file, you can use the following method to &quot;filter&quot; the file. This method does not save worksheet elements that are not available in Microsoft Excel version 2.x; for example, graphic objects will not be saved.



MORE INFORMATION
Use the appropriate method for your version of Excel.

Microsoft Excel 7.x and 97

 * 1) Open the file that appears to be corrupted.
 * 2) On the File menu, click Save As.
 * 3) In the Save As Type list, click SYLK (Symbolic Link), and then click Save.

NOTE: Only the active sheet in the workbook is saved when you use the SYLK file format. Click OK on the warning message that appears when you save in SYLK format. If you have multiple worksheets, you can save each sheet as a separate SYLK file.
 * 1) On the File menu, click Close. When you click Close, you will be warned that the file you are closing is not in the normal Microsoft Excel format. Click the No button to save it as a SYLK file.

Clicking Yes will resave the file in the normal Microsoft Excel format, and this will not strip out any of the file information.
 * 1) On the File menu, click Open.
 * 2) Select the .slk file you saved in step 3, and click Open.

NOTE: To see the .slk file, you may need to click All Files (*.*) in the Files of Type list.
 * 1) On the File menu, click Save As.
 * 2) In the Save as Type box, click Microsoft Excel Workbook (*.xls), and then click Save.

Microsoft Excel for Windows, Versions 4.0 and 5.0

 * 1) Open the file that appears to be corrupted.
 * 2) On the File menu, click Save As.
 * 3) In the Save File As Type list, click SYLK, and then click OK.

NOTE: Only the active sheet in the workbook is saved when you use the SYLK file format. Click OK on the warning message that appears when you save in SYLK format.
 * 1) On the File menu, click Close. When you click Close, you will be warned that the file you are closing is not in the normal Microsoft Excel format. Click the No button to save it as a SYLK file.
 * 2) On the File menu, click Open.
 * 3) Select the .slk file you saved in step 3, and then click OK.

NOTE: To see the .slk file, you may need to click All Files (*.*) in the List Files Of Type list.
 * 1) On the File menu, click Save As.
 * 2) If you are using Microsoft Excel version 4.0:

In the Save As Type list, click Normal, and then click OK.

-or-

If you are using Microsoft Excel version 5.0:

In the Save File As Type list, click Microsoft Excel Workbook, and then click OK.

Microsoft Excel for the Macintosh, Version 5.0 and 98

 * 1) Open the file that appears to be corrupted.
 * 2) On the File menu, click Save As.
 * 3) In the Save File As Type list, click SYLK (Symbolic Link).
 * 4) In the Save As box, type a new name for the file, and then click Save.

NOTE: Only the active sheet in the workbook is saved when you use the SYLK file format. Click OK on the warning message that appears when you save in SYLK format.
 * 1) On the File menu, click Close. When you click Close, you will be warned that the file you are closing is not in the normal Microsoft Excel format. Click the No button to save it as a SYLK file.
 * 2) On the File menu, click Open.
 * 3) Select the file you saved in step 4, and click Open.

NOTE: To see the file, you must click Readable Files in the List Files Of Type list.
 * 1) On the File menu, click Save As.
 * 2) In the Save File as Type list, click Microsoft Excel Workbook, and then click Save.

Earlier Versions (Windows and Macintosh)

 * 1) Open the file that appears to be corrupted.
 * 2) On the File menu, click Save As.
 * 3) Click Options, click SYLK in the File Format box, click OK, and then click OK again.
 * 4) On the File menu, click Close. When you click Close, you will be warned that the file you are closing is not in the normal Microsoft Excel format. Click the No button to save it as a SYLK file.
 * 5) On the File menu, click Open.
 * 6) If you are using Microsoft Excel for Windows:

In the File Name box, type *.slk. Then, select the .slk file, and click OK.

-or-

If you are using Microsoft Excel for the Macintosh:

Select the .slk file, and click Open.
 * 1) Click Save As on the File menu.
 * 2) Click Options. Then, in the File Format box, click Normal and click OK.
 * 3) Click OK (Microsoft Excel for Windows) or click Save (Microsoft Excel for the Macintosh).

After you save the file in the SYLK format, if the file still appears to be corrupted, copy and paste the entire contents of the file to a new worksheet.

If neither of these methods corrects the problem, you may want to install Microsoft Excel on another computer to determine whether your Microsoft Excel disks are corrupted. If the disks work correctly on another computer, the problem may be related to other hardware or software on the computer with the problem in Microsoft Excel.

Possible reasons for file corruption include the following:


 * You are using a memory-resident Windows program or a Macintosh extension program that causes data to be stored incorrectly in memory or on disk.
 * You are using an incompatible disk-partitioning program.
 * Your Microsoft Excel disks are damaged.

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.20 3.0 4.00 5.0 corrupt XL

Keywords: kbprb KB45557

Technology: kbExcel500 kbExcel95 kbExcel95Search kbExcel97Search kbExcel98 kbExcel98Search kbExcelMacsearch kbExcelSearch kbExcelWinSearch kbHWMAC kbOSMAC kbZNotKeyword3

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.