View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default 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?