Value Field Name is lost in Pivot Tables...

  • Thread starter Thread starter RM
  • Start date Start date
R

RM

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table field drop-down not refreshing 1
Formula fields in Pivot Tables? 1
Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2
about pivot table 1
Pivot table - value field settings - default? 2
Field Formatting in Pivot Tables 1
Pivot Table field names don't match 1

Back
Top