Pivot Table Field - How to default Subtotals to None?

[XLML]

Hi,

When creating a pivot table, the fields that I drag to Row have Subtotals set to Automatic in the Pivot Table Field dialog. Is there a way to default this to "None"?

Thanks in advance,
XLML

 

[XLML]

Hello,

Is this possible? Is there a generic macro that will change this default for any row fields in a pivot table?

Thanks in advance,
XLML