How to set classic pivot table layout in Excel?
As we known, the pivot table layouts are different in Excel 2003 and Excel 2007 or higher. And if you are preferring to the classic pivot table layout (in Excel 2003), how can you set the pivot table layout back to classic in Excel 2007 or higher versions?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Actually, there is an option for you to change the pivot table layout to Excel 2003’s classic layout in Excel.
1. Right click at any cell in the pivot table to show the context menu, and select PivotTable Options. See screenshot:
2. In the PivotTable Options dialog, click Display tab and check Classic PivotTable Layout (enables dragging fields in the grid) option. See screenshot:
3. Click OK to close the dialog, and now the pivot table layout change.
If you want to set all pivot table layout of a workbook to be classic, you can save the workbook as 97-03 workbook firstly, and then insert pivot tables.
1. Click on the Office button or File tab, and click Save As. See screenshot:
2. In the Save As dialog, select the folder you want to locate the workbook, then select Excel 97-2003 Workbook from Save as type list. See screenshot:
3. Click Save to close the dialog. Then all pivot tables you will insert in future in the workbook are showing as classic pivot table layout automatically.