How can you disable automatic sorting in pivot tables?

Answer:

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’.