Pivot Table

K

Kevin McCartney

Hi, is there a 'Change' event associated with a Pivot Table 'Page Field' I need to be able to execute code after a Page Field is updated. I assume there is because if you change a field the the Pivot table is updated and my associated graph is also updated, thus I want to execute my code as well, when this change is made, I just don't know where to added it too.

TIA
KM
 
K

Kevin McCartney

Or do I add my code to the SheetCalculate event and check the cell value of the cell address that my pivot table page fields use?
 
D

Debra Dalgleish

In Excel 2002 you can use the PivotTableUpdate event:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
MsgBox "Changed"
End Sub
 
Top