VBA code to uncheck "Sort automatically every time the report is updated" of Pivot table?

[Gottoplay]

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

[shg]

PivotField.AutoSortField Property?

[Gottoplay]

PivotField.AutoSortField Property?

No , that only provides which data field you are sorting on.

[shg]

Sorry, I don't know then. I could count on one hand the times I've automated pivot tables.