gkisystems
Board Regular
- Joined
- Apr 20, 2012
- Messages
- 76
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?
By default, Excel has it set to "Automatic." How can I change the default to "None" for all my Excel files?