PivotTable Events?
 

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?

PivotTable Events?
 

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



"Mitch Powell" wrote in message
...
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?

PivotTable Events?
 

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.

"Patrick Molloy" wrote:

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



"Mitch Powell" wrote in message
...
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?

PivotTable Events?
 

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

"Mitch Powell" wrote in message
...
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.

"Patrick Molloy" wrote:

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



"Mitch Powell" wrote in message
...
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?

PivotTable Events?
 

Perfect. Thank you very much!

"Patrick Molloy" wrote:

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

"Mitch Powell" wrote in message
...
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.

"Patrick Molloy" wrote:

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



"Mitch Powell" wrote in message
...
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?