Keeping Your Slicers Synced

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:

  • Your pivot tables don’t share the same data source
  • You want to synch a filter on a table with a pivot table filter
  • You want to have custom filter buttons

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.

Data Modelling & Formulas