Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
do events? background events | Excel Programming | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
PivotTable - PivotTable Field name is not valid - error! | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |