When you try to open an Excel Workbook in Microsoft Office Excel 2003, you might encounter 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.”
This error message might be followed by the underwritten error message when you try to save file:
“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.”
The problematic workbook might open without any problem with earlier versions of Microsoft Excel.
Grounds of this issue
You might encounter this behavior of Microsoft Excel if the particular workbook is corrupted or damaged. It might take place though the workbook opens in earlier version of Excel without any issue.
In such conditions, to gain access of your mission critical data, you need to perform Excel Recovery by fixing this scenario as quickly as possible.
Resolution
To easily and effectively handle the situation, follow the below mentioned steps:
. Open the workbook in earlier version of Microsoft Excel.
. Copy data from it and then paste to a new workbook opened in Excel 2003.
. Save the file.
This method works in most of such cases and allows you to have easy Excel Repair. But if Excel does not allow you to even open the workbook due to extensive corruption, then you might not resolve the problem using this process.
In such situations, you are advised to go for excel recovery software to systematically scan the corrupted file and extract all of its data and objects out from it. Excel Repair software are generally very easy to use and enable you to have safe and original Excel Recovery.
Stellar Phoenix Excel Recovery is the most comprehensive and result-oriented excel repair tool that can handle most of the Excel corruption scenarios. Phoenix Excel Repair software works well with Microsoft Excel 2007, 2003, 2002 and 2000.