Microsoft KB Archive/162376

= 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:


 * 1) Select the cell that contains the field header for the field that you want to sort.
 * 2) 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

-

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

© Microsoft Corporation. All rights reserved.