Hi,
I have multiple pivot tables and 3 slicers - Site, Year and Month
I don't want to display the slicer on the report but somehow change the slicers based on a cell value - Site, Year and Month.
Site is in Cell E5, Month, in E6 and Year in E7
How can I change the slicers based on these cell values.
Slicers are linked to 5 graphs - graph 5,6,7,10,11.
Help much appreciated.
Thanks
Bookmarks