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

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.

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

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.
   
4. 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.

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

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.