Subtotals in Pivot tables

[David Mann]

I'm building a pivot table with quite a few columns. By default excel puts a column subtotal and doesn't repeat the row labels. I can remove the subtotals and make the labels repeat from the field menu. I wondered if there was somewhere no subtotals and repeat labels could be set as the default?

 

[Johnny C]

Sadly no. You get what MS decide you want. And unfortunately you can't do a setting so when you open a workbook it applies to any. To do it with VBA is probably possible but complicated as the VBA references the table (easy to get) and the currently selected field. You'd need to cycle through all the fields in the active pivot table and turn summarise off and row labels on