Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table Classic Display

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Pivot Table Classic Display

Resolved · Low Priority · Version 2010

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Excel articles

· What Is A Sparkline And How Do They Work?
· When A Number's More Than A Number, Use Excel
· How To Share Files In Excel 2010
· Employing Cell References in Excel
· Reporting and Analysis with Excel

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips