slicercache

I want to change the workbook slicer style to “SlicerStyleDark5 2” when I run this but I get the message “Wrong number of arguments or invalid property assignment”. Can you help? Sub DarkBlue()Dim slc As SlicerCache Dim sl As Slicer Dim I As Long For Each slc In...

Caught the video on youttube which led me to this link: (https://www.mrexcel.com/news/sync-slicers-in-excel/). I pasted the code and it's crashing on me when it gets to the For Each line of the code, I get a runtime error '1004' application defined or object-defined error. My code is barely...

Hi, I have 4 data sources and 10 pivots so I created 4 slicers. To link the 4 slicers, I wrote this VBA but it is not working. Can someone please help? Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) Dim sc1 As SlicerCache Dim sc2 As SlicerCache Dim sc3 As...

Here is the dilemma I am running into. I am designing a report that will be viewable by both managers and employees. I have slicers attached to Employee, Level 1 Manager and Level 2 Manager fields that control all the pivot tables. The issue is, once I run the code upon opening the workbook...

Hello VBA MVPs, The below code typically works for standard pivot tables, but fails on line 42 (oSc.SlicerItems.Count) under " 'Targeting the Slicer that needs to be synched" when trying to access SlicerItems in a SlicerCache linked to a Power Pivot Data Model Pivot Table. Can anyone kindly...

Good afternoon, I am trying to loop through all the sliceritems in a slicercache but I keep encountering errors. Can anyone spot the error in the macro below? Thank you! Option Explicit Sub Slicers() Dim SCache As SlicerCache Dim SItem As SlicerItem Dim SItem2 As SlicerItem...