Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive a "Damage to the file was so extensive that repairs were not possible" error message when you try to open a workbook in Excel 2003


View products that this article applies to.

Symptoms

Describes an error meesage you may receive when you try to open a workbook in Excel 2003. This problem may occur although the workbook opens with no problems in an earlier version of Excel.When you try to open a workbook in Microsoft Office Excel 2003, you may receive the following error message:
Errors were detected in 'filename.xls,' but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.

Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.

↑ Back to the top


Cause

This problem may occur if the workbook is damaged or corrupted and may occur although the workbook opens with no problems in an earlier version of Excel.

↑ Back to the top


Workaround

To work around this problem, you may be able to copy and paste the data from the workbook opened in an earlier version of Excel to a new workbook in Excel 2003.

Note You must have both versions of Excel installed on the same computer to use this work around.

↑ Back to the top


Keywords: KB820712, kbprb, kberrmsg, kbopenfile, kbrepair

↑ Back to the top

Article Info
Article ID : 820712
Revision : 6
Created on : 1/11/2006
Published on : 1/11/2006
Exists online : False
Views : 272