refresh event pivot

[Guest]

I'd like to know simple code to trigger my code on a refresh or change event
on a pivot. Just not sure how to get it to activate..

thanks,

 

[Guest]

If you are using XL2002 or better then there is a refresh table event in VBA.
In the sheet with the pivot table add this code...

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub

If you are using a version of XL prior to 2002 then there is no event and
you need to catch the calculate event or something similar which carries a
lot of overhead with it...