XL97: How to Use the PivotTable AutoSort Feature

Last reviewed: March 13, 1998
Article 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

  1. Select any single cell in the PivotTable, and then click the PivotTable Wizard on the PivotTable toolbar.

    Step 3 of the PivotTable Wizard appears.

  2. Double-click the field button you want to sort in the Row or Column fields.

  3. In the PivotTable Field dialog box, click Advanced.

  4. In the "PivotTable Field Advanced Options" dialog box, click Ascending or Descending.

    NOTE: You can click a different field in the "Using field:" list.

  5. Click OK.

  6. Click OK again in the PivotTable field dialog box.

    Step 3 of the PivotTable Wizard appears.

  7. Click Next, to set more options, or click Finish to complete the PivotTable.

New PivotTable

  1. Open the workbook where you want to create the PivotTable.

  2. If you are basing the PivotTable on a Microsoft Excel list or database, click a cell in the list or database.

  3. Start the PivotTable wizard by clicking PivotTable Report on the Data menu.

  4. Follow the instructions in the wizard until you see step 3 of the wizard.

  5. In step 3 of the PivotTable Wizard, construct the PivotTable by dragging the desired field buttons into position on the diagram.

  6. 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 : xlpivot xlui kbualink97 kbfaq
Version : WINDOWS:97
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 13, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.