Excel Pivot Table Caches and Slicers

jaustin

New Member
Joined
Jun 6, 2017
Messages
29
Using Excel Pro Plus and have a large table (over 100,000 rows and 100 columns) that has been added to the Data Model. I've created several Pivot tables from the Power Pivot/Manage/Pivot Table option and had a set of 16 slicers attached to 10 Pivot Tables. They were all responding correctly to the set of slicers. I've created a new Pivot Table in the same manner (from the Data Model) and then created a new set of slicers (using many of the same column names). The connection menu for the slicers shows all Pivot Tables (including the recent one). I've tried to connect the slicers to just the new Pivot Table but the original slicer set follows the new selection. I've created the slicers from the new Pivot Table and don't understand why the two sets of slicers are synchronized.

There is something I'm not understanding or doing wrong. I checked through VB and I have 13 separate Pivot Table caches.

Thanks in advance,

jaustin
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,214,784
Messages
6,121,536
Members
449,037
Latest member
tmmotairi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top