XL: Handling Corrupt MS Excel Files by Saving in the SYLK Format

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, versions 2.x, 3.x, 4.x, 5.0, 5.0c
• Microsoft Excel 98 for the Macintosh
• Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0, 5.0

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 "filter" 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

Follow the steps that are appropriate for the version of Excel you are using.

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.

4. On the File menu, click Close.

5. On the File menu, click Open.

6. 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.

7. On the File menu, click Save As.

8. 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.

4. On the File menu, click Close.

5. On the File menu, click Open.

6. 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.

7. On the File menu, click Save As.

8. 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.

5. On the File menu, click Close.

   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.

6. On the File menu, click Open.

7. 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.

8. On the File menu, click Save As.

9. 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.

5. On the File menu, click Open.

6. If you are using Microsoft Excel for Windows:

   In the File Name box, type "*.slk" (without the quotation marks). 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.

7. Click Save As on the File menu.

8. Click Options. Then, in the File Format box, click Normal and click OK.

9. Click OK (Microsoft Excel for Windows) or click Save (Microsoft Excel for the Macintosh).

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.