slcr

Dear Experts, I have a large data set in a table - A:G with 13k rows and 6 slicers. I would like to setup a default view when opening the excel worksheet that would - 1) refresh all data in a table 2) hide all table data/make slicers free of any filter selection. I also use below vba as a...

Hi All I have this code that clears all slicer filters on my sheet How can i clear all the slicer filters except for the slicer called type? Sub SlicerReset() Dim slcr As SlicerCache Dim slc As Slicer Application.ScreenUpdating = False Application.Calculation = xlCalculationManual For...

Hi, Am currently the code below to Reset Slicers on a worksheet and it works fine but takes too long (30sec+). Quicker to do it manually. Is there any way to optimize code to run faster?? Appreciate any help:) Private Sub ClearAllSlicers_Click() Dim slcr As SlicerCache Dim sl As...