PivotTable Is Not Sorted Correctly After Updating Data
Article ID: 162376
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 98 for Macintosh
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.
Additional query words: 98 97 XL98 XL97 alphabetical order unsorted arrange 5.00a 5.00c refreshed resort refreshing re-sort XL
Keywords: kbbug KB162376