PivotTable Events?

  • Thread starter Thread starter Mitch Powell
  • Start date Start date
M

Mitch Powell

I need to run some code whenever a PivotTable's data cache is updated but I
don't see any events associated with this. Am I missing something?
 
how is the cache updated? if its done by code, then you can just add the
pivot's refresh method

if the data cache is a table of data on another sheet, then you could use
that sheet's Change event to refresh the pivot cache
 
The PivotTable is linked to an MS Access table and is updated manually by the
user using the "Refreash Data" command on te Data menu.
 
there is a pivot event fired by an update ... i can't access a database just
now, but if the database link is refreshed, surely the pivot table
refreshes?

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub
 
Perfect. Thank you very much!

Patrick Molloy said:
there is a pivot event fired by an update ... i can't access a database just
now, but if the database link is refreshed, surely the pivot table
refreshes?

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub
Click to expand...
 
Back
Top