philkeoghan
New Member
- Joined
- Sep 23, 2009
- Messages
- 13
Hi I have a workbook that I have made multiple pivot tables on one sheet which works well and can use the slicer tool of 2010 and effectively filter all the pivot tables at one using it's connections which is really good.
What I need to be able to do is show the filter pages for these pivots, I can do them one by one but I then have to go move all the pivots back to there corresponding sheets, is there a way to do show filter pages for one field which applies to multiple pivot tables and generate multiple tables to the one sheet then move on to the next
hope that sort of makes sense
I can upload a file and give you an example of what I need
Thanks
What I need to be able to do is show the filter pages for these pivots, I can do them one by one but I then have to go move all the pivots back to there corresponding sheets, is there a way to do show filter pages for one field which applies to multiple pivot tables and generate multiple tables to the one sheet then move on to the next
hope that sort of makes sense
I can upload a file and give you an example of what I need
Thanks
