Hi all,

These forums have helped me quite a bit over the past few months as I've gotten to grips with a new job that required a lot more Excel use than before, and today I'm hoping you can help with a problem I'm having. The below code is used to change the date filter on all the pivot tables in a worksheet when I change the pivot on this tab:

Please Login or Register  to view this content.
This worked just fine in a worksheet I built before, but another worksheet won't accept it. Changing the pivot on this tab now resets all the other pivots to have no date filter, rather than the selected one. Strangely, the (blank) filter is the only one left unselected (which exists because I've built the pivot tables using columns rather than a range).

Example: My data has 01/09/2012 and 01/10/2012 as possible filters. Changing Pivot 1 to show 01/10/2012 should automatically change Pivot 2 to the same date. But it doesn't, rather Pivot 2 gets it's filter reset to show both dates, but not (blank).

This leads me to believe that the problem doesn't occur until:

Please Login or Register  to view this content.
But I can't figure out why... Can anyone shed some light on this, please?