Pivot Table Change Event??
Posted by JAF on February 12, 2001 7:53 AM
I have a file with two worksheets - one contains source data, the other contains 3 pivot tables (I realise not the ideal way to set it up, but that's what the client has asked for!)
Each Pivot Table has the same page field (Month). Is there any way to run a macro whenever the page field on any of the pivot tables changes so that the other 2 pivot tables on the sheet always show the same month?
I guess that I'm looking for something like a Worksheet_Change event, but specific to the pivot tables.