Renaming Cells linked to Pivot Tables

G

gsimmons2005

Hey guys,

Is there a way to rename the field heading that are linked to th
pivot tables, so when I click update data, it just takes on the ne
name.

Right now if I just rename the heading, the pivot falls apart....

any ideas? Thanks! :confused
 
C

Chris Segrave

click on the title of the row/column in the pivot (so the data is not
highlighted) and change it in the formula bar...

or is that what you mean by the heading???
 
G

gsimmons2005

I want to change the original cells that the pivots are linked to.


IE.

Dog is a heading with
1
12
3



pivot will use this, but once I rename Dog it goes to hell, can
rename the original and keep the pivot in tack
 
Top