In this post we will see how could we stop auto sorting and auto formatting of pivot table in excel after we have refreshed the pivot table.
The tendency of pivot table in excel to auto sort the items after we refresh it could lead to several other issues like formatting issue e.g. the column width may get disturbed, the decimal formatting may also get affected.
To avoid those formatting issues in pivot table in excel, we could stop pivot table from auto sorting it when we refresh it.
Below is step by step explanation of how to stop auto sorting and auto formatting in pivot table.
We have a pivot table as shown in the pic below and we would like pivot table not to perform auto sorting when refreshed.
We could easily achieve that by Sort option in Pivot table Options.
Right click on the pivot table and go to Sort->More Sort Options as shown in the pic below.
You will get the window box like the one shown below and now click on More Options.
Now you will get window box like the one shown below and now uncheck “Sort automatically every time the report is updated” option to disable auto sort in pivot table after refresh and press OK.
Now after disabling this option your pivot table will not auto sort when you will refresh pivot table in excel.
Hope this helped.