View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default classic pivottable layout

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