I have Excel 2007. I am currently working on a problem where a user has 5 pivot tables, all of them show various data, but they are using the same data as a filter. Is there any way I can get all of them to filter when I filter PivotTable1? I have seen some code in other threads for macros, but I haven't found anything that has worked for me yet. HELP!
Bookmarks