XL2000: Handling Corrupted Excel Files by Saving in the SYLK Format
| Article ID | : | 214147 |
| Last Review | : | November 5, 2003 |
| Revision | : | 1.0 |
This article was previously published under Q214147
For a Microsoft Excel 2002 version of this article, see 300639 (http://support.microsoft.com/kb/300639/EN-US/).
For a Microsoft Excel 98 and earlier version of this article, see 45557 (http://support.microsoft.com/kb/45557/EN-US/).
For a Microsoft Excel 98 and earlier version of this article, see 45557 (http://support.microsoft.com/kb/45557/EN-US/).
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
| 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 when you receive the message telling you that the selected file type does not support workbooks. Click Yes when you receive the message telling you that the file may contain features that aren't compatible with the SYLK format. If you have multiple worksheets, you can save each sheet as a separate SYLK file. |
| 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, and then click Save. |
