Classic View – Pivot Tables

I’m Creating a Pivot table but the layout initially looks like what it did in version 2003. How do I change it to the modern layout?

Version 2003 Classic Pivot Table Display

Classic pivot.png

  1. In version 2013,2016 Select Analyze
  2. In Version 2007,2010 Select Options


  1. Ensure your cursor is in the Pivot Table
  2. From the Analyze Tab/Options
  3. From the Display tab in the dialog box
  4.  Un-tick Classic PivotTable layout



2007 to 2016 Pivot Table Standard Layout Display


Related Topics

Dynamic data for pivot tables

Excel Training Courses Sydney – Power Pivots and Pivot Tables

Excel Course




About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: m: 0414 417 059
This entry was posted in Excel. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s