Renaming a Pivot Table Value Field
When you add a field to the pivot table Values area, it’s automatically given a custom name, such as Sum of Units.
You might want to change the custom name to Units, so it’s easier to read and makes the column narrower.
However, if you select the cell and type Units, you’ll get an error message: “PivotTable field name already exists.”
Use a Slightly Different Name
If you try to create a custom name that’s the same as a field name in the source data, you’ll see the error message. In this example, because one of the fields in the source data is named Units, you can’t use Units as a custom name in the pivot table.
However, you can avoid this problem, by adding a space character to the end of the custom name, and it will be accepted.
Or, if you have multiple value fields in the pivot table, select all the captions, and use the Replace All command to fix all the captions at once.
- In the Find What box, type “Sum of”
- Leave the Replace With box empty
- Click Replace All.
This will leave a space at the start of the caption, so it’s different than the original field name, and will be accepted.