98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Classic Display
Pivot Table Classic Display
Resolved · Low Priority · Version 2010
Fri 10 Feb 2012, 10:56Delegate Lucie said...
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
Mon 13 Feb 2012, 08:47Trainer Mark said...
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
Mon 20 Feb 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly insert a functionIn Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog. |
