slicer cache

I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...

So I have a sheet that has a pivot table in the "Pivot Table Reference" tab, that has a slicer called reviewee name. Based on what is selected on that slicer that pivot table is referenced in a sheet on the "Output Sheet" tab. What I need is some kind of a VBA cycle code that can automatically...

I'm getting an Application-defined or object-defined error on SI.Selected = False. Can anyone help? Everything I've tried based on my research has failed. [ Sub TestSlicer() Dim sC As SlicerCache Dim sI As SlicerItem Dim index As Integer Set sC =...

Good morning, all! I have been stuck on this issue for days and hope someone can help. I have a table on Sheet2 [Sheet2.Range("A2:O" & LastRow)] that gets copied to a table on Sheet1 [Sheet1.Range("Table1")] through a macro. The table on Sheet 1 starts on D17 and goes to the last row in...

Hi All, I have a "slicer" that is connected to a Calendar table with "Date Hierarchy" like this "[Calendar].[Date Hierarchy].[Week]" "[Calendar].[Date Hierarchy].[Month]" "[Calendar].[Date Hierarchy].[Year]" What I would like to do know is change the level of slicer to correspond to changes made...

Just a heads up, this is my first time asking a question on a MrExcel forum. So apologies in advance if I don't follow the etiquette. I have 3 pivot tables, each with its own data set and each has 3 slicers. The data in the pivot tables has different values and is of a different size. However...

I am trying to create a macro (button) to format all slicers to a certain style on the active worksheet. I have multiple worksheets that are nearly identical (copied from a master sheet), but the following code only works on the original sheet. How do I change the slicer name to apply to all...

Hi, I have the below code which clears the slicer filters fine but for some reason isint working on the timeline filters. Would anyone know what I need to add to clear the timeline filters? <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...

Hi, Could anyone advise me on possible reason for the compile error below? I was looking for solution how to replace Pivot table filters by slicers, and intended to have particular values selected on these slicers. I asctually already had manually created the slicers there, so there was dual...

Is there a way to apply code to all slicers at once, without having to call out each slicer cache and each slicer item in each of those caches? I have 4 slicers, each has 2 - 104 items in it. I would like to run some code so that when all items for all caches are TRUE, then data labels are...

hi all, Im working on a macros involving different pivot tables and slicers. When I run the following: ActiveWorkbook.SlicerCaches.Add(ActiveSheet.PivotTables("sAPivot"), _ "KPI 1 Percentage").Slicers.Add ActiveSheet, , "KPI 1 Percentage", _ "KPI 1 Percentage", 155, 490, 145, 200...