K
KB
Hi All,
I have a sheet of data, and a pivot table on another sheet that uses the
data. When I change the name of a data field, the data field disappears from
the pivot. I would have thought that the name would just update. The new
data name is in the field list, but having to go into the field list and
drag it out to the pivot is not very practical.
Has anyone noticed this issue? Is there a way to make this work?
Essentially the pivot is filled with place holder data names (Data1, Data2,
etc.). The real names are filled in later after the workbook is distributed
around the company, so the manipulation of the pivot is out of my hands, and
multipled many times over (over 50 workbooks go out).
Thanks for any advice,
KB
I have a sheet of data, and a pivot table on another sheet that uses the
data. When I change the name of a data field, the data field disappears from
the pivot. I would have thought that the name would just update. The new
data name is in the field list, but having to go into the field list and
drag it out to the pivot is not very practical.
Has anyone noticed this issue? Is there a way to make this work?
Essentially the pivot is filled with place holder data names (Data1, Data2,
etc.). The real names are filled in later after the workbook is distributed
around the company, so the manipulation of the pivot is out of my hands, and
multipled many times over (over 50 workbooks go out).
Thanks for any advice,
KB