Pivot Tables

Hi Alhagie,

Thank you for the forum question.

Here’s how you can set Excel to always default to the classic view for PivotTables:

Open Excel and go to the File tab.
Select Options to open the Excel Options dialog box.
In the Excel Options dialog box, go to the Data tab.
Click on the Edit Default Layout button.
In the Edit Default Layout dialog box, click on PivotTable Options.
Under the Display tab, check the box for Classic PivotTable Layout (enables dragging of fields in the grid).
Click OK to save your settings.
This will set the classic layout as the default for all new PivotTables you create.

For any existing PivotTables, you can change them to the classic layout by right-clicking on the PivotTable, selecting PivotTable Options, and then checking the Classic PivotTable Layout option under the Display tab.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector