Is there a way to change the pivot table default settings so that a new pivot
table is always generated in the "Classic Pivot Table Layout" display? I am
trying to avoid checking the little box located under "Pivot Table
Options/Display".

Hi,

There are not global pivot table options which are under our control, I
would suggest the only thing you could do is create a macro, put it in the
personal macro workbook and assign a shortcut key to it.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Darron" wrote:

Is there a way to change the pivot table default settings so that a new pivot
table is always generated in the "Classic Pivot Table Layout" display? I am
trying to avoid checking the little box located under "Pivot Table
Options/Display"..

Kind of what I thought, but wanted to throw the question out there anyway.

Thanks!

"Shane Devenshire" wrote:

Hi,

There are not global pivot table options which are under our control, I
would suggest the only thing you could do is create a macro, put it in the
personal macro workbook and assign a shortcut key to it.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Darron" wrote:

Is there a way to change the pivot table default settings so that a new pivot
table is always generated in the "Classic Pivot Table Layout" display? I am
trying to avoid checking the little box located under "Pivot Table
Options/Display"..