Pivot Table Default

  • Thread starter Thread starter JDebo
  • Start date Start date
J

JDebo

Is there any way to change the Default Pivot Table Options?
The Classic Pivot table is much easier to interpret.
 
Hi

As far as I am aware, there is no setting where you can make this the
default.
The following code will change the layout. You could assign a shortcut key
to it, and use that to make the change after the PT was created.

Sub ClassicPT()
With ActiveSheet.PivotTables(1)
.InGridDropZones = True
.RowAxisLayout xlTabularRow
End With
End Sub
 
Back
Top