title: How to make 'Clear Slicers' Code More Efficient?
body: <p>I'm working with six slicers on a summary sheet in Excel 2010. Each slicer is connected to 26 pivot tables.</p>
  
  <p>I used the code below in the past to clear slicer selections and it worked with minimal lag. This time the code takes 6-7 seconds to execute. </p>
  
  <pre><code>Dim oSlicerC As SlicerCache
  
  For Each oSlicerC In ActiveWorkbook.SlicerCaches
      oSlicerC.ClearManualFilter
  Next oSlicerC
  </code></pre>
  
  <p>I can't find anything online to speed up the macro/make it more efficient.</p>
  
  <p>I tried setting <code>ScreenUpdating</code>, <code>DisplayAlerts</code>, and <code>EnableEvents</code> to <code>False</code> and I tried setting <code>Calculation</code> to <code>xlCalculationManual</code> at the beginning of my code.</p>
  
  <p>I thought about iterating through each <code>SlicerItem</code> to de-select each one, but with up to 100 items in a few slicers I'm not sure that would be any faster.</p>
  
  <p>I'm not looking for code as I'd like to take a stab at it myself, but I'm not sure which path I should take or if there's even a more efficient alternative to what I'm already using.</p>