There's no way to turn the feature off. You can use programming to turn
off all the subtotals, as in the sample code he
http://www.contextures.com/xlPivot03.html#Subtotals
jenn wrote:
is there a way to turn off the auto-subtotal when using pivot table fields? I
turned of the grand totals, but I still end up having to double click on the
column name and choosing none from the subtotals for every column.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html