pivot tables

[bichteler]

hi!

does anybody know how to set certain Pivot field settings as default?

The problem:
when i add a colum to my pivot table it shows me the count of each value
instead of the sum.
so i change it manually from count to sum. when i now remove that specific
colum and add it later on again, it
lost the setting and shows me again the count and not the sum.

please help.

florian

 

[Ken Wright]

It will do this automatically any time you have blanks or text within your
data. Either fix the source data, or assign a routine to a shortcut that
changes it for you, eg:-

Sub MakeAllSum()

Dim pf As PivotField

For Each pf In ActiveSheet.PivotTables(1).DataFields
pf.Function = xlSum
Next pf

End Sub

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------