Set Default PivotTable Layout Options
If you use PivotTables often, you've probably wished there was a way to set default PivotTable layout options. For example, if you prefer Tabular instead of the default Compact, it sure would be nice if all new PivotTables used the Tabular layout. Well, depending on the version of Excel you have, you may in fact be able to edit the default PivotTable layout right now :-)
Written tutorial and sample file:
https://www.excel-university.com/set-...
