subject: Resolving excel Found Unreadable Content.. Error Message In A Ms Excel Workbook [print this page] Also known as a spreadsheet, a workbook is a collection of cells on a single sheet where you can store or manipulate data. At times, you may observe some issues in the Workbook due to which you fail to access the content stored in it. This happens due to corruption of Workbook, which causes the inaccessibility of data. To access your data, you will need a valid data backup file. However, if the backup is not present, or corrupt, then you need to use a third-party application, known as excel repair software to retrieve your data completely.
For instance Sometimes, when you try to access a MS Excel workbook, you encounter the below mentioned error message:
Excel found unreadable content in Book_Name. Do you want to recover the contents of this workbook?
When you click Yes, you get the following Excel recovery report:
Removed Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
In case your workbook is published on a Microsoft SharePoint Web Part report page, then it will not render. In addition, you receive the following error message:
The workbook that you selected cannot be opened. The workbook may be in an unsupported file format, or it may be corrupt. Would you like to try and open this file in Excel?
This error message states that the Workbook is corrupt or damaged. As a result of corruption, the file may not open and the data becomes inaccessible.
Cause:
Following can be the possible causes for the above issue:
A PivotTable that uses key performance indicator (KPIs) is there in the workbook.
The KPIs are created in the Analysis Services Business Intelligence Development Studio.
One or more KPIs have are present in the Current Time Member property.
Resolution:
To resolve the above issue, consider the following measures:
The above issue can be resolved by removing the expressions or presence of KPIs from all Current Time Member properties.
In case, the workbook gets corrupted, you fail to access the contents present in the file. In such situations, you need to repair excel file to retrieve and restore the data from the corrupted or damaged Workbook file. Such excel repair application employ high-end scanning mechanisms to quickly scan and repair the damaged file. Due to their interactive user interface, these tools are easy to use and understand without any prior technical skills.
