Get your own customer support community
 

Why won't my changes of the "Value Field Settings" in a pivot table stick?

I'm using excel 2007, and after altering a value field setting in a pivot table (from "count" to to "sum" for example), it loses the new settings when I take it away from the "Value" area, changing automaticaly the value field setting from "sum" to "count" again.
How can I avoid this?
 
sad I’m frustrated
Inappropriate?
2 people have this question

User_default_medium