Pivot Table Default
 

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

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.