Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
In Excel 2002 you can use the PivotTableUpdate event:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
MsgBox "Changed"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse 2
Automatically Update a Pivot Table Field Used as Column / Row 1
Pivot table multiple filters 2
Unable to Group in Pivot Table 1
Using VBA on Excel Pivot Tables 3
Help list box to update pivot table 1
VBA Pivot Table Change Criteria - Help?! 1
dynamic pivot table selection 1

Back
Top