mduff
02-02-2010, 09:29 AM
Hi,
I have a worksheet with 7 pivot tables in one worksheet what I am looking to do is when one of the pivot tables report filter is updated it will update on all of them so I have the filter to be on work weeks if I change one of them to 4 I would like all of them to be updated to 4 same if I select multiple items :dunno
Please note I am using excel 2007 if this will make a difference.
Please let me know if you have any questions and thanks in advance
I have a worksheet with 7 pivot tables in one worksheet what I am looking to do is when one of the pivot tables report filter is updated it will update on all of them so I have the filter to be on work weeks if I change one of them to 4 I would like all of them to be updated to 4 same if I select multiple items :dunno
Please note I am using excel 2007 if this will make a difference.
Please let me know if you have any questions and thanks in advance