![]() |
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