View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RM RM is offline
external usenet poster
 
Posts: 23
Default Value Field Name is lost in Pivot Tables...

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.