Forum

I should add that I am trying to put the code is two different macros so I can run "disconnect" then "reconnect" independently.

Turns out I actually did have the same slicer linked to 2 pivots with the same name. I think maybe it let me because the pivots were on different she...

When I tested the code I received this error: Run-time error '457: This key is already associated with an element of this collection When I d...

To further clarify, it runs an OLAP query every time you change anything with the slicers and that is the main hold up.

The spreadsheet accesses information on a server and performs massive calculations so each time you edit a slicer it takes 30-90 seconds before you ca...