How do I make pivot table default to classic view?

Simply so, how do I make pivot table default to classic?

Figure 1.

1. Click the Data option.
2. Click the Edit Default Layout button.
3. Click the PivotTable Options button.
4. Make sure the Display tab is selected.
5. Click the Classic PivotTable Layout check box.
6. Click OK to dismiss the PivotTable Options dialog box.
7. Click Cancel to dismiss the Edit Default Layout dialog box.

Likewise, what is classic pivot table layout? Right click at any cell in the pivot table to show the context menu, and select PivotTable Options. In the PivotTable Options dialog, click Display tab and check Classic PivotTable Layout (enables dragging fields in the grid) option. See screenshot: 3.

Similarly, you may ask, how do I change the view of a pivot table?

To change the layout:

1. Select a cell in the pivot table.
2. On the Ribbon, under the PivotTable Tools tab, click the Design tab.
3. At the left, in the Layout group, click the Report Layout command.
4. Click the layout that you want to uses, e.g. Show in Outline Form.

How do I change Excel to classic view?

To get started, go to File > Options > Data > Click the Edit Default Layout button. Layout Import - Select a cell in an existing PivotTable and click the Import button. That PivotTable's settings will be automatically imported and used in the future.