Worksheet_change event: Refresh pivot located in another sheet

[PATSYS]

What is wrong with this code? It is in the worksheet module of Sheet1

Private Sub Worksheet_Change(ByVal target As Range)

    Sheets("Sheet2").PivotTables("PivotTable1").PivotCache.Refresh

End Sub

Thanks in advance

 

[GlennUK]

And what happens when that code runs?

 

[PATSYS]

Hi GlennUK,

Sorry for late response.

I figured out what's wrong. The pivot was in a different sheet (not Sheet2).

Thanks anyway.