Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how the relationships between the slicers, pivot tables, and pivot caches work in Excel, and how all these objects are connected.

Read the full article: https://www.excelcampus.com/pivot-tables/connected-filters-error/

I explain the filter controls error that occurs when trying to change the source data range of a pivot table that is connected to multiple slicers.

There are two solutions for this error. The first method is to disconnect the slicers from the pivot tables, change the source data range for each pivot table, then reconnect the slicers.

The second (better) method is to use Excel Tables for the source data ranges of your pivot tables. The Tables automatically extend to include new data, and you never have to update the source data range when new rows are added. This also prevents the filter control connections error because both pivot tables will always share the same cache. Here is an article and video on a Beginners Guide to Excel Tables. https://www.excelcampus.com/tables/excel-tables-tutorial-video/

Learn more about PivotPal here: https://www.excelcampus.com/pivotpal

Please leave a comment below with any questions. Thank you!
00:00 Introduction
01:16 Slicer Pivot Table Cache Relationshhip
04:05 Disconnect Slicer from Pivot table
05:19 Use an Excel Table