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.

AFIK you can't. When you remove the dimension from the table the settings are
lost...
--
HTH...

Jim Thomlinson


"RM" wrote:

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.

I thought so...darn it

Thanks for the reply!

"Jim Thomlinson" wrote:

AFIK you can't. When you remove the dimension from the table the settings are
lost...
--
HTH...

Jim Thomlinson


"RM" wrote:

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.