Microsoft KB Archive/284885

= XL2002: Data Selection Is Not Updated in PivotTable Report After Changes Are Made to Data Source Query =

Article ID: 284885

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q284885





SYMPTOMS
When you create a Pivot Table in Microsoft Excel 2002 and you attempt to filter the data from an ODBC data source, the data is not updated in the Pivot Table.



CAUSE
The Auto Starting at check box in the Grouping dialog box is not selected for a data field in the Pivot Table.



WORKAROUND
Select the Auto Starting at check box in the Grouping dialog box. To do this, follow these steps:
 * 1) In the PivotTable, select the cell that contains the header for the grouped data fields.
 * 2) On the Data menu, point to Groups and Outline, and then click Group.
 * 3) Under Auto, click to select the Starting at check box, and then click OK.


 * 1) Reapply the filter to the data in the Pivot Table using the Pivot Table Wizard.

Alternatively, you can clear both the Auto Starting at and the Auto Ending at check boxes in the Grouping dialog box and then select a value or date large enough to include all the data that you want. Then, reapply the filter to the data in the Pivot Table using the Pivot Table Wizard.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
For more information about creating a PivotTable Report, click Microsoft Excel Help on the Help menu, type Create a PivotTable report in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: XL2002

Keywords: kbbug kbnofix KB284885

-

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

© Microsoft Corporation. All rights reserved.