The default Excel Pivot Table layour is Automatic subtotal and show items in outline form. However most of my Pivot Table need to be formatted with no sub-totals and tabular form. is there a way to set the default field settings to no sub-totals and tabular form ?
Hello,
you don't specify your Excel version. In general, the settings you describe cannot be set as a default. You could record a macro that turns an out-of-the-box pivot table into the shape you desire. Adjust it to run on the selected pivot table and store the macro in your Personal.xlsb so you can use it in any file you open.
Teylyn,
Thanks for the response. I am using Excel 2013.
The settings is on each field so I don't think a recorded macro will work. I would like to know If there is a way to use recorded macro to set all the fields in a PT to the above settings.
After becoming tired of repeating the same formatting sequence to do exactly what you describe, I created as small vba add-in which makes this one right-click away. There are also a few other commands like customizing the number formats that you may find handy.
It is available here: https://onedrive.live.com/redir?resid=3E6CE26277A3F633%21107
Use or modify freely.