XL97: How to Use the PivotTable AutoSort FeatureLast reviewed: March 13, 1998Article ID: Q156314 |
The information in this article applies to:
SUMMARYIn Microsoft Excel 97, there is a new PivotTable feature called AutoSort. This feature allows you to automatically sort a PivotTable when you create it, or when you refresh a PivotTable after you change data in the PivotTable.
MORE INFORMATIONA PivotTable is an interactive table that summarizes and analyzes data from existing lists and tables. In earlier versions of Microsoft Excel, it is possible to sort PivotTable fields in ascending or descending order; however, if you refresh the PivotTable after you make edits or additions to the source data you may get unexpected results. For example, the PivotTable may append new items to the end of the list rather than sort the items within the list. To sort a PivotTable in which you changed data, you must sort the PivotTable after each refresh. The new AutoSort feature for PivotTables in Microsoft Excel 97 automatically sorts a PivotTable despite changes you make to the underlying data. You can access the following three basic AutoSort settings in the "PivotTable Field Advanced Options" dialog box: Manual, Ascending, and Descending. If you select Ascending or Descending, fields that you specify are sorted in ascending or descending order respectively. To access AutoSort, use the following methods according to whether the PivotTable already exists.
Existing PivotTable
New PivotTable
REFERENCESFor more information about working with PivotTables, click the Index tab in Microsoft Excel Help, type the following text
PivotTables, sortingand then double-click the selected text to go to the "Sort data in a PivotTable" topic.
|
Additional query words: 97 XL97 Pivot Table
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |