I have the following problem.
I am using VBA to create a pivot table. There are several data fileds selected, with several row items. I can disable creating row grand totals by .RowGrand = False, and the same for the column grand totals.
However, Excel creates subtotals for each data item which I can not disable from the VBA code. Is there any method or property that I can use here?