Microsoft KB Archive/106358

Microsoft Knowledge Base

XL: Changing Calculation Type Doesn't Change Data Field Name

Last reviewed: June 3, 1997
Article ID: Q106358

5.00 7.00 97 | 5.00

WINDOWS      | MACINTOSH

kbusage kbtool

The information in this article applies to:

• Microsoft Excel for Windows, version 5.0
• Microsoft Excel for the Macintosh, version 5.0
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows

SUMMARY

When you work with a pivot table in Microsoft Excel, the name of the data field does not change when you change the calculation type for that field.

MORE INFORMATION

The data field name in a pivot table defaults to the summary function for that data field. For example, a field called "Sales" that contains numeric data will be given a default name of "Sum of Sales." A field called "Product" that contains text will be given a default name of "Count of Products." This default name will also change with the summary function for that data field. If you change the function you choose in the Summarize By list for "Sales" from Sum to Count, the data field name will change to "Count of Sales."

However, the field name will not change when you change the calculation type for that field. For example, if you change the calculation type for the "Sales" field to "% Of Column," the field name will not change to "Sum of Sales as Percent of Total Sales."

To rename a pivot table data field, use the following appropriate steps:

Microsoft Excel 97

1. Right-click the cell that contains the data field you want to rename and click Field on the shortcut menu.
2. Type the new name in the Name box and click OK.

Microsoft Excel 5.0 and 7.0

1. Select the cell that contains the data field you want to rename.
2. On the Data menu, click PivotTable Field.
3. Type the new name in the Name box and click OK.

REFERENCES

"User's Guide," version 5.0, page 510

For more information about Changing The Name Of A Pivot Table Field, choose the Search button in Help and type:

    pivot tables, changing information in

KBCategory: kbusage kbtool KBSubcategory: xlpivot Additional reference words: 5.00 7.00 97 Keywords : kbualink97 xlpivot kbtool kbusage Version : 5.00 7.00 97 | 5.00 Platform : MACINTOSH 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: June 3, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.