View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Pivot Table Events

In excel 2002 and 2003 (I believe 2002 was where they were added), there are
some pivottable associated events, but they belong to the application,
workbook and worksheet objects. You can go to the object browser and search
on pivot, then scroll through the results looking for the lightning bolt
icon signifying an event.

--
Regards,
Tom Ogilvy

"Blue Aardvark" wrote in message
...
Is there any way to run some code before a pivot table automatically

updates?
Unlike query tables, there seems to be no exposed events for the pivot

table
object.

Thanks.