Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

Spreadsheets Microsoft Excel MS Office Automation Microsoft Office MS Office tools
user-image
Question added by jhangeer bazmi , Freelance Graphics Designer
Date Posted: 2017/03/15
Upvote (1) Views (35) Followers (5) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Sharon Urbanes-Silao
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

Faridullah Khan
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

NEHA NEGAR ALAM
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.

Hasantha Wickramarathne
by Hasantha Wickramarathne , Quantity Surveyor , KEO International Consultants

Turn Off Pivot Table Autosort.

Write Your Answer
More Questions Like This