Pivot table not refreshing sort order
- by William Anthony
I have Pivot Table that get its data source from another sheet, same workbook.
I want the sort order of data is same as the data source order, I choose "Sort in data source order" in Pivot Table option.
The problem is, when I change the data order on data source worksheet, then I refresh the Pivot Table, the sort order didn't change.
I googled…