Remove Classic Pivot Table View
Do you still like your classic view in Pivot Tables in Microsoft Excel, or do you prefer the modern view but can’t get out of the classic view? In version 2013, 2016 you will find in the Microsoft Excel Ribbon that it is now called Analyze instead of Options. Look for the options command usually found to the left of the Ribbon.
Remember in Microsoft Excel versions 2007 and 2010 you will find it under the tab call Options and then again you are looking for a command button called Options. From the Display tab in the dialog box, you will need to Un-tick or Tick as you like “Classic Pivot Table layout” which enables you to drag and drop fields into the Column and Row items area.
Creating functions to incorporate dynamic data is something you would have done in the past but now in Microsoft Excel Pivot Tables, there is a feature in Microsoft Excel versions 2010, 2013 and 2016 which now has “Format as Table” allowing your data to increase as you add more records – “rows of data” and add new fields – “columns of data”.
This means you don’t have to go to the data source consistently to add those extra few rows of data or new columns of data.
Microsoft Excel Version 2003 Classic Pivot Table Display view.
Microsoft Excel Version 2016 Ribbon
Microsoft Excel Options Dialog Box
Microsoft Excel Version 2007 to 2016 Pivot Table Standard Layout Display