XL97: How to Use the PivotTable AutoSort Feature
ID: Q156314
|
The information in this article applies to:
-
Microsoft Excel 97 for Windows
SUMMARY
In 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 INFORMATION
A 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
- Select any single cell in the PivotTable, and then click the
PivotTable Wizard on the PivotTable toolbar.
Step 3 of the PivotTable Wizard appears.
- Double-click the field button you want to sort in the Row or Column
fields.
- In the PivotTable Field dialog box, click Advanced.
- In the "PivotTable Field Advanced Options" dialog box, click Ascending
or Descending.
NOTE: You can click a different field in the "Using field:" list.
- Click OK.
- Click OK again in the PivotTable field dialog box.
Step 3 of the PivotTable Wizard appears.
- Click Next, to set more options, or click Finish to complete the
PivotTable.
New PivotTable
- Open the workbook where you want to create the PivotTable.
- If you are basing the PivotTable on a Microsoft Excel list or database,
click a cell in the list or database.
- Start the PivotTable wizard by clicking PivotTable Report on the Data
menu.
- Follow the instructions in the wizard until you see step 3 of the
wizard.
- In step 3 of the PivotTable Wizard, construct the PivotTable by dragging
the desired field buttons into position on the diagram.
- After you construct the PivotTable, repeat steps 2 to 7 in the "Existing
PivotTable" section.
REFERENCES
For more information about working with PivotTables, click the Index tab in
Microsoft Excel Help, type the following text
PivotTables, sorting
and then double-click the selected text to go to the "Sort data in a
PivotTable" topic.
Additional query words:
97 XL97 Pivot Table
Keywords : kbualink97 xlui xlpivot
Version : WINDOWS:97
Platform : WINDOWS
Issue type :