اكسل

Slicers are visual filters. You can filter a pivot table or chart by adding  a slicer on any field. Do you know that you can link slicer to more than one pivot table? Yes, this advanced usage of slicers makes it handy to update multiple reports with one click.

To link multiple pivot tables to same slicer:

1. Right click on the slicer and select “Report connections”
2. Check pivot tables that you want to connect.
3. Done.

You can use the same approach to link multiple pivot tables with a timeline too.