Hi All

Is there a way I can change the default layout of Excel 07 Pivot Tables?

Every time I create a chart I also go to Pivot Table Options, Display, And Click to show classic PivotTable layout (enables dragging of field in the grid)

I would like this to be always selected if possible.


any ideas?

ty
SP