To run a macro every time I select an option of a pivot table I used the event handler WS_change. Unfortunately this doesn't work for Pivot Tables so I used the WS_calculate but this option slow down the process and is producing other little problems in my worksheet.
Is there any better method to run a macro after any Pivot table change?.
thanks in advance for your reply
Is there any better method to run a macro after any Pivot table change?.
thanks in advance for your reply