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"..