I renamed the value field names in my pivot table. When I removed certain
columns in the pivot table, then later want to add it, the name is lost along
with the settings (ie. sum, and number with no decimals).
If possible, how can I make this where anytime I remove and add it back it
won't lose the settings?
Thanks,
RM
By the way, I'm using Excel 2007.
Jim Thomlinson - 29 Feb 2008 20:28 GMT
AFIK you can't. When you remove the dimension from the table the settings are
lost...

Signature
HTH...
Jim Thomlinson
> I renamed the value field names in my pivot table. When I removed certain
> columns in the pivot table, then later want to add it, the name is lost along
[quoted text clipped - 7 lines]
>
> By the way, I'm using Excel 2007.
RM - 29 Feb 2008 23:55 GMT
I thought so...darn it
Thanks for the reply!
> AFIK you can't. When you remove the dimension from the table the settings are
> lost...
[quoted text clipped - 10 lines]
> >
> > By the way, I'm using Excel 2007.