Hi SandyXYZ,
Welcome to the MSDN forum!
In excel, there are no options available to turn this automatic sorting off or to perform a custom sort on your PivotTable data. To prevent a PivotTable from being sorted, you can create a custom list using the unsorted source data on the worksheet. To custom
sort a PivotTable, you can first sort the source data as the way you want it on the worksheet, and then create a custom list using the sorted source data.
You can refer to the KB for more details on this issue.
Thanks.
Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
