How can you disable the automatic sorting of information in a pivot table?
- Sharad Jaiswal
- 22nd Feb, 2018
1 answer(s) :
-
Reply
"
To disable the automatic sorting of information in a pivot table, follow these steps:
- Select any cell within the pivot table.
- Go to the "PivotTable Analyze" tab in the ribbon.
- Click on the "Options" tab in the "PivotTable" group.
- In the "Data" section, uncheck the box next to "Sort automatically when the report is created".
- Click "OK" to close the dialog box.
- This will disable the automatic sorting of information in the pivot table.
- Any changes you make to the underlying data will not be reflected in the pivot table until you manually refresh it.
- To refresh the pivot table, select any cell within the table and press the "Alt+F5" keyboard shortcut or click the "Refresh" button in the "Data" section of the "PivotTable Analyze" tab.
Post your Answer :
Valid name is required.
Valid name is required.
Valid email id is required.
Devquora
28th Apr, 2023