Lucie has attended:
Excel Advanced course
Pivot Table Classic Display
Hi,
When I build a pivot table, I only habe the option to choose the fields using the Field list on the right hand side. I don't have the option to drop fields directly into the pivot table.
To correct this, I have to click Options (under Pivot Table Tools), then Options (left hand side), Display tab, and tick 'Classic PivotTable layout (enables dragging of fields in the grid)'.
I'm having to do this each time I create a pivottable - is there any way to set this as a default?
Thanks
RE: Pivot Table Classic Display
Hello Lucie,
Unfortunately setting the Classic view of the pivot is not possible according to Microsoft, However, some users report that by setting the pivot to classic view and saving in the Personnel Book (the default settings) has worked, although I cannot confirm this.
Other users, report that once they change to classic it always displays classic view???
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
