Changing field names without affecting pivot table

[csdjj]

I have 15 pivot tables that have all been created using the same source data.
Unfortunately, the person who will be using the pivot tables wants to change
the names of some of the fields I'm using.

As far as I can tell, every time I change the name of a field in my source
data, the pivot table no longer recognizes that field and I have to re-create
all of my pivot tables again.

Is there any way avoid this?

Thanks for your help!

 

[Jim Thomlinson]

You can not change the field names in your source data without messing up
your pivot tables. You could rename the fields within your pivot tables but
if it is a global change to all then you might be best off to just change the
source and then deal with the pivots.

 

[csdjj]

Thanks, Jim. (Not the answer I wanted -- but it was the answer I was
expecting!)