View Single Post
  #5  
Old April 6th, 2008, 07:47 AM posted to microsoft.public.excel.newusers
dan
external usenet poster
 
Posts: 1,408
Default classic pivottable layout

I already tried that method, it works only for the current PivotTable next
time I create a new one I have to manually change it again. perhaps it's the
only way to set it up.
thank you

"Bob Umlas, Excel MVP" wrote:

On the Options tab pf the PivotTable Tools, the leftmost group, PivotTable,
click Options, then click Options. In that dialog, click the "Display" tab,
and use the 4th checkbox, "Classic Picottable layout"
Bob Umlas
Excel MVP

"Dan" wrote:

I want to know how can I set the default for the classic Pivottable layout in
version 2007. I've tried the pivottable options display tab and checked
the Classic Pivottable layout, didn't work. ~thank you