How can we disable the automatic sorting in pivot tables in ms excel ?

Start networking and exchanging professional insights

Next Question:
How to create a pivot table in Excel 2013?
Posted by:
Mohammed El Tahir Mohammed Yousif
21-March-2017

Spreadsheets Microsoft Excel MS Office Automation Microsoft Office MS Office tools

Question added by jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
Date Posted: 2017/03/15

Upvote (1) Views (34) Followers (5) Answers (4) Report Question

Write an Answer
Register now or log in to answer.

4 Answers

by Sharon Urbanes-Silao , Assistant / Document Controller , Dalkia-EDF Middle East

Go To > More Sort Options > Right Click ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically

Upvote (0)

Downvote Reply () Report

by Faridullah Khan , accountant , Ghayat General Transport

To disable automatic sorting in pivot tables: Go To > More Sort Options > Right Click ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically

Upvote (0)

Downvote Reply () Report

by NEHA NEGAR ALAM , INTERN , PERTS Consultancy Firm

For this yo first need to select the heading click on sort under pivot table options, then click more options, next click off Autosort , and then try to save the file.

Upvote (0)

Downvote Reply () Report