Change the defaults for your Pivot Tables by:
Selecting FILE
OPTIONS
DATA
Edit Default Layout
Categories: Excel Tips
Excel Pivot table Defaults
When you create pivot tables in Excel, do you have to change the Layout to the form that you want? Do you always change it to repeat all labels and not show subtotals? Using the Read more