If you are creating a Pivot table but the layout initially looks like what it did in version 2003. “How do you change it to the modern layout?”. 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 PivotTable layout”
which enables you to drag and drop fields into the Column and Row items area.
If you work often in Microsoft Excel’s Pivot Tables, then you might like to know about the new feature in Microsoft Excel versions 2010, 2013 and 2016 which now has “Format as Table” this feature allows 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 sources consistently to add those few extra rows of data or new column of data.
Microsoft Excel Version 2003 Classic Pivot Table Display
Microsoft Excel Version 2016 Ribbon
Microsoft Excel Options Diaog Box
Microsoft Excel Version 2007 to 2016 Pivot Table Standard Layout Display