ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet.PivotTableUpdate event (https://www.excelbanter.com/excel-programming/357216-worksheet-pivottableupdate-event.html)

Pointrider

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.


All times are GMT +1. The time now is 06:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com