Save Pivot Sheet Settings
The Save Pivot Sheet Settings feature saves the following display settings for the opened favorite view:
- Column width
- Sorting order
- Column sequence
The functionality can also be automated by checking Automatic Save Display Settings for Favorite Views, which will hide the button in the pivot sheet.
The following steps help you to save Pivot sheet settings: