How do I set defaults for "PivotTable Options?"

[gkisystems]

In the PivotTable Options pop-up box on the Data tab, I like to set the "Number of items to retain per field:" box to None.

By default, Excel has it set to "Automatic." How can I change the default to "None" for all my Excel files?

 

[texasalynn]

take a look at this
Changing the Default PivotTable Style in Excel 2007