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.
|