Hello,

I have question, is there some VBA code to uncheck the "Sort automatically every time the report is updated" of a Pivot table.

I have spent many hours searching for info on this.
I tried to record a macro, but it comes out blank.

Manually, you click on the drop down arrow - select "More sort options..." - select "More options" in the next window - and uncheck "Sort automatically every time the report is updated".

I need to do this through VBA. Is it possible?

Thanks