PivotTable Is Not Sorted Correctly After Updating Data (162376)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q162376 SYMPTOMS
When you update a PivotTable in Microsoft Excel, the fields in the
PivotTable may not be sorted even though the data that is used to create
the PivotTable changes.
CAUSE
When you click Refresh Data, Microsoft Excel updates the data in the
PivotTable, but does not perform a sort operation on the updated data.
WORKAROUND
To work around this problem, follow these steps:
- Select the cell that contains the field header for the field that
you want to sort.
- On the Data menu, click Sort. In the Sort dialog box, click OK.
The updated data in the PivotTable is sorted correctly.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbbug KB162376 |
|---|
|