 | |
| Slicer Pivot Table Cache Relationship and the Filter Controls Error |
Learn how the relationships between the slicers, pivot tables, and pivot caches work in Excel, and how all these objects are connected. 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.
Related Topics:
Post a Comment