Set pvtC = wb.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=stageWs.Range("A1:L" & dataWsLastRow), _
Version:=xlPivotTableVersion15)
Set pvtT = pvtC.CreatePivotTable(TableDestination:=stageWs.Range("N1"), TableName:="Staging Area")
With pvtT
.ColumnGrand = False
.RowGrand = False
.PivotFields("Depth, ft").Orientation = xlColumnField
.PivotFields("Number").Orientation = xlRowField
.PivotFields("Pr").Orientation = xlDataField
.PivotFields("SW").Orientation = xlDataField
End With
How do I disable the auto sorting by ascending order? I want the pivot table to render the data as-is...Thanks!