slicer cache

  1. N

    VBA Store Slicer Selection, Run Macros, Re-Select Slicers

    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...
  2. H

    VBA - How to change slicer cache level

    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...
  3. J

    Cycling through slicer items

    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...
  4. N

    VBA for Slicer Formatting

    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...
  5. S

    Clearing Timeline and Slicer Filters

    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...
  6. A

    Turning on/off slicer fields by VBA - compile error

    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...
  7. S

    Applying code to all slicers?

    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...
  8. D

    "The Slicer Cache already exists" error macros

    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...

This Week's Hot Topics

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
Top