Classic PivotTable Layout
I wish there was a default setting to force pivot tables to use the "classic"
layout, but failing that, I'm looking to create a macro that runs whenever a
pivot table is created. I've got this code that works, but only within the
current workbook. How do you get Excel to automatically recognize when a
pivot table is being created to change the layout to classic?
With ActiveSheet.PivotTables("PivotTable1")
.InGridDropZones = True
.RowAxisLayout xlTabularRow
End With
|