I'm working on an excel file that has to be compatable with 2007 so I can't use splicers. I have a file with around 15 different pivot fields. Each table has a field that is used to determine location. I would like to have a drop down that is not in the pivot table where the person selects the location and all 15 pivot tables uses that value to filter the data.
I'm struggling to find something that works. Any help would be great.