Article ID: 928731
Article Last Modified on 5/14/2007
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office SharePoint Server 2007
SYMPTOMS
When you click Filter in the drop-down menu for a PivotTable report in Microsoft Office Excel 2007, the data appears in a way that is incorrect. This issue occurs when you use Excel Services in Microsoft Office SharePoint Server 2007.
CAUSE
This problem occurs because the data for the PivotTable has changed in the source database.
WORKAROUND
To work around this problem, delete and then re-create the PivotTable in Excel 2007.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR
Keywords: kbcorrupt kbpivottable kbtshoot kbprb KB928731
