PivotTable Events?

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?
 
P

Patrick Molloy

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
 
M

Mitch Powell

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.
 
P

Patrick Molloy

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
 
M

Mitch Powell

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...
 
Top