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

Last reviewed: February 2, 1998
Article ID: Q45557

The information in this article applies to:
  • 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).

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.2 2.20 3.0 3.00
4.0 4.00 5.0 5.00 7.00 corrupt
Version : WINDOWS:2.x,3.x,4.x,5.0,5.0c,7.0,97; MACINTOSH:2.2,3.0,4.0,5.0,98
Platform : MACINTOSH WINDOWS
Issue type : kbprb
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.