Good Morning:
Does anyone know how to Rename Fields within a Pivot Table? I.E: Sum of Budget to Budget. The "Sum of" is an Excel default but it won't let me rename because it says "Budget" already exists? These Fields are in the Data area.
Thanks!
The trick is to add a space before the name. Excel doesn't want you to give a calculated field the same name as a variable in the Pivot Table, but it's OK to use an existing name if you add a space in front. (perhaps a space behind will work as well...)
Marc
Like this thread? Share it with others