Default pivot table layout

When you create a Pivot table report there are several options that you can use to influence its appearance. These can be some of the settings in the Options menu, and you can also change the Report Layout by selecting from the menu located in the Design ribbon. What’s new in Excel 2019 is that you can now set the default Pivot table report layout so that each new report looks the way you want it …

Let’s run File/Options … The settings for dealing with data are located within the Data tab. Here are a few of them that can help you influence the performance of the Data Model, as well as the ability to include “traditional” data import options. Specifically, as of 2019, all links to external sources go through Power Query; if you want to import data the way you did before, this should be enabled by selecting one of the options, for each data source, from this menu. Clicking the Edit Default Layout button enters the window to set the default Pivot report layout.

After the window opens, Excel will first prompt you to import a view from an existing report. By entering the address of one of the cells within the Pivot table in the Layout Import box, clicking on Import will import the settings. They can also be set manually. In the window you can see the options for displaying the subtotals and grand totals, the option to select Report Layout, as well as a few others that you have had the chance to meet before. Clicking on the Pivot table Options enters the traditional Options dialog box. After selecting all the desired display options and clicking OK, the settings for the default layout of the new table are saved. If you ever change your mind, clicking the Reset to Excel Default button returns the default appearance of the report.