Cause:
This error message may occur if the workbook file is corrupted or damaged.
Resolution:
Data retrieval from workbook becomes important as it contains your valuable information. Following measures can be used to recover the contents of the spreadsheet.
Use Microsoft Office Application Recovery tool to recover the data from workbook.
Use ‘Open and Repair’ tool.
Try to save the file in HTML format.
Try to save the file in XML spreadsheet format.
Use a macro to extract the data from the chart in a workbook.
In most cases, you would be able to solve the issue using these measures.
However, if the problem still persists and you badly require the workbook, then you need to use an Repair Excel software to retrieve your data from the corrupted Excel file. You must ensure that the repair software is a reliable application that scans and Repairs Excel File by employing high-end scanning mechanisms. The repair tools must restore the data from the Excel file without any modifications or alterations in the original contents of the file. Also, the utility should offer interactive graphical user interface that makes repair procedure user-friendly, self-explanatory and does not require any prior technical skills.