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???

"gsimmons2005" wrote:


Hey guys,

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

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

any ideas? Thanks!


--
gsimmons2005
------------------------------------------------------------------------
gsimmons2005's Profile: http://www.excelforum.com/member.php...o&userid=26385
View this thread: http://www.excelforum.com/showthread...hreadid=466893