View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pointrider Pointrider is offline
external usenet poster
 
Posts: 6
Default Worksheet.PivotTableUpdate event

I'm trying to use this event to apply some formatting to the pivot table
after it is updated by the user choosing a page field entry, and also to
sort the Grand Totals column. The pivot table is automatically updated
through the worksheet.Activate event.

For some reason, I don't get a single Worksheet.PivotTableUpdate
event... I get (literally) hundreds of them. Can anyone shed any light
on this? I also see hundreds of Worksheet.Calculate events... I'm stumped.