Error message when you try to open a workbook in Excel 2007: "Excel found unreadable content in Book_Name"

When you try to open a Microsoft Office Excel 2007 workbook, you receive the following error message: When you click Yes, you receive the following recovery report: Alternatively, if the workbook is published to a Microsoft SharePoint Web Part report page, the workbook does not render. Additionally, you receive the following error message:

This issue occurs if the following conditions are true:

• The workbook contains a PivotTable that uses key performance indicators (KPIs).
• The KPIs are created in the Analysis Services Business Intelligence Development Studio.
• One of more of the KPI's have an expression ithe Weight property.
• One or more of the KPIs have an expression in the Current Time Member property.

To resolve this issue, remove the expressions from all Current Time Member�and weight on the KPI properties.

The Current Time Member property is an optional property. It is used to display the time period that the KPI covers to a Microsoft SQL Server Analysis Services (SSAS) client.