Set classic pivot table layout with check option. Amazing! Set classic pivot table layout with saving as 9703 workbook. If you want to set all pivot table layout of a workbook to be classic, you can save the workbook as 9703 workbook firstly, and then insert pivot tables. Relative Articles: display classic pivot table How to display grand total at top in pivot table? As we all know, the grand total row is at the bottom of the pivot table in default, but sometimes, in order to view the grand total quickly and easily, you need to put the grand total row at the top of the pivot table.
May 21, 2013 VBA Code to change pivot tables to classic view Become a Registered Member (free) to remove the ads that appear in thread area. Click here to reset your password. display classic pivot table
Click on the Pivot Table so that you can see the Pivot Table contextual tabs. 2. From the Options tab click the Options button (on the far left of the Ribbon, in the Pivot Table group). 3. Click the Display tab. 4. Select Classic PivotTable layout (enables dragging of fields in the grid). 5. Click OK. Your Pivot Table will now be displayed in the classic view. Difference between the new and classic pivot table: The new version group the Row Labels together (I don't usually want that) Right click ON the pivot table PivotTable Options. Click Display tab and check Classic PivotTable layout. We are not done yet, if you want to see merged cells for grouped rows: Its the same setting in fact, you can change that setting from the Design tab in ribbon or in Pivot Table options. As usual, the most frequently used commands are displayed in the right click menu too, not only in the Pivot Table Tools tab from ribbon. display classic pivot table Jan 20, 2019 I would like to know if it is possible to default EXCEL 2010 to display pivot tables in the classic layout. This thread is locked. You can follow the question or vote as