Article ID: 929766
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Excel 2007
SYMPTOMS
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:
CAUSE
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 or more of the KPIs have an expression in the Current Time Member property.
RESOLUTION
To resolve this issue, remove the expressions from all Current Time Member properties.
MORE INFORMATION
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.
Additional query words: xl2007
Keywords: kberrmsg kbtshoot kbpivottable kbprb kbexpertiseinter kbexpertisebeginner KB929766