Stop pivot table from sorting when refreshed

[btadams]

In a pivot table when click on the Row Labels or Column Labels drop-down you can go to More Sort Options -> More Options and uncheck the Sort Automatically every time Report is Updated. What exactly does this do? I have a pivot table I've manually sorted and I don't want it to change when the pivot table is refreshed. Will this option do that or does it just stop sorting when the underlying data table is updated? Also does anyone know what the VBA code is to set this option to False? I tried using the macro recorder but it didn't give me anything.

Thanks,
BTAdams

 

[GraH]

Hi, as far as my experiences goes, simply leaving the sort option "manual" does what you want. If you have arranged your sorting manually, a refresh will not overwrite that sort. Meaning if new items show up, they will appear below in the pivot (row labels), after the items you manually sorted before.

Not sure what the advantage is. I usually sort my pivot tables explicitly (be it on a custom list, a dimension or value) or not at all. I'm oblivious when it concerns VBA. Seems you can force a sorting by position per pivot item.