A new Excel feature as part of the May release providing an ability to enable users to personalize the default layout for PivotTables.
This feature available as part of an Office 365 subscription for Excel 2016 on Windows, and enable you quickly start your favorite PivoTable layout when you’re building complex reports or performing one-off analyses.
To personalize PivotTable layout setting for the deaults, you can either simply click the newly added “Edit Default Layout” button located under the “File menu” to display the Edition Default Layout dialog and make changes to any of your favorite layout options. All the settings in the “Layout” chunk of the PivotTable Design contextual ribbon as well as the PivotTable Options dialog are included.
Or, secondly, from you workbook import a layout and customize it by simply open up the Edit Default Layout dialog, then click anywhere within a PivotTable in workbook and then click Import button.
Along with, also included a tip when using OLAP connections to make PivotTables much faster. Disabling Subtotals and Grand Totals will help taking advantage of performance improvements delivered in a previous update to Excel 2016.
In Edit Default Layout dialog, simply set Subtotals option to Do Not Show Subtotals and set Grand Totals option to Off for Rows and Columns.
This tip can work alongside changes to all the other options in the Edit Default Layout dialog.
To learn more about how you can use this new feature, visit our support page.