Excel Slicers are a very versatile way to synchronize filtering on pivot tables and charts in your reports and dashboards.
And if your data model is properly designed they should all work together seamlessly.
However, situations may occur where you cannot synchronize slicers using standard filtering if:
In such cases, you’ll need VBA to synchronize the slicers. In this session, you will learn how to set up the VBA code needed to make this happen.