Pivot Table Options - Default Display Settings

  • Thread starter Thread starter Darron
  • Start date Start date
D

Darron

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
 
Back
Top