I have four Pivots tables that all use the same data (the data is on a worksheet in the same file as the pivots). Is it possible to have ONE set of filters control the behavior of all four pivots simultaneously?
If you are using pivot tables then you have slicers? in the drop down on the slicer in the ribbon you can choose the Slicer Connections window to connect multiple pivots and from there filter all by the slicer