Pivot table question

[Badnames]

I am trying to add roughly 80 fields to my values section. The only problem is this takes a long time to do manually. In the pivot table wizard, whenever I check each box for the field setting I want to add to values, they default add to the rows section. Also if I drag the field selection into the values section, it defaults to count rather than sum. Is there a way to change these two defaults? Anyone know how I can add a selection of fields to the values section quickly all to be summed? Please let me know. Thanks.


I am running excel 2007.

 

[Andrew Poulsom]

Count will be the default if there is text in the fields.

 

[Badnames]

Only the column header is text. Do I need to remove this? Also still need to know how to add the fields to values section quickly rather than rows.

 

[Badnames]

Changed all the values to numbers, they still default to count.

 

[Badnames]

Got an add in which helped me tremendously. It is called PivotPower, you can download it below. The add in lets you change all the fields instantly, which is what I needed.

http://www.contextures.com/xlPivotAddIn02.html

Now if only there was a way to add fields more quickly to the values section...