Microsoft KB Archive/928731

= Data appears in a way that is incorrect when you click Filter in the drop-down menu for a PivotTable report in Excel 2007 =

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 &quot;Applies to&quot; section.

Additional query words: XL2007 Excel2007 MOSS2007 XLServices ExcelServices ECS EWR

Keywords: kbcorrupt kbpivottable kbtshoot kbprb KB928731

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.