Change the Pivot Table from another sheet

[Ongbey]

Hi,

There is a Pivot Table on the "OT" Sheet and I want to change it from another sheet.

For example, I can use the following command while on the "OT" sheet. However, I need a similar code to do the same thing from another sheet.

With ActiveSheet.PivotTables("PivotTable1").PivotFields("UKod")
.Orientation = xlRowField
.Position = 2
End With

 

[FormR]

Hi, you can try like this:

With Sheets("OT").PivotTables("PivotTable1").PivotFields("UKod")
    .Orientation = xlRowField
    .Position = 2
End With

 

[Ongbey]

Great, thank you.

Hi, you can try like this:

With Sheets("OT").PivotTables("PivotTable1").PivotFields("UKod")
    .Orientation = xlRowField
    .Position = 2
End With