How can you disable the automatic sorting of information in a pivot table?

devquora

devquora

Posted On: Feb 22, 2018

1 Answer Written

Answered by devquora
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.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

Can you provide an overview of Microsoft Excel?

Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..

Can you explain the concept of spreadsheet?

Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...

What do you mean by ribbon?

The ribbon in MS Excel is a user interface at the top, replacing traditional menus. It organizes commands into tabs like Home, Insert, and Formulas for easy access to various functions, enhancing user..