Pivot Table Default
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
--
Regards
Roger Govier
"JDebo" wrote in message
...
Is there any way to change the Default Pivot Table Options?
The Classic Pivot table is much easier to interpret.
|