ianb Member Jan 13, 2013 #1 Hi I have 6 pivot tables and they are all set to one date. How Can I with VBA have that if I change one then they all chnage to the same date. The date is shown either on the first row or as a top item. They are all on the same work sheet Thanks.
Hi I have 6 pivot tables and they are all set to one date. How Can I with VBA have that if I change one then they all chnage to the same date. The date is shown either on the first row or as a top item. They are all on the same work sheet Thanks.
ianb Member Jan 13, 2013 #2 Pivot table 1 is the same as pivot tabel 2 and 3 yet 4 does not need to change. I would like this that either 1,2 or 3 can be changed. Also 5 and 6 are the same with a different field and I would ike them to be linked together. Thanks.
Pivot table 1 is the same as pivot tabel 2 and 3 yet 4 does not need to change. I would like this that either 1,2 or 3 can be changed. Also 5 and 6 are the same with a different field and I would ike them to be linked together. Thanks.
Faseeh Excel Ninja Jan 14, 2013 #3 Hi ianb, Please see these links: http://blog.contextures.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/ http://chandoo.org/forums/topic/change-the-criteria-of-multiple-pivot-tables-at-once, Regards,
Hi ianb, Please see these links: http://blog.contextures.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/ http://chandoo.org/forums/topic/change-the-criteria-of-multiple-pivot-tables-at-once, Regards,
