title: Connect a slicer to ll pivot table
body: <p>Status Quo:<br>
  I have an excel 2010 workbook with a worksheet named <em>Data</em>. All the pivot tables in the workbook draw from that sheet. I have another sheet named <em>Board</em> where all the slicers are, and every slicer is connected to all pivot tables in the workbook.  </p>
  
  <p>Need:<br>
  I have to overhaul the file quite often, adding some columns in <em>Data</em> and some more pivots and slicers. Of course, pivot cache won't update automatically. Therefor new pivots can't be associated to old slicers.  </p>
  
  <p>Strategy:<br>
  1_ I'd like to get a macro to detach all slicers from all pivot tables. This way if I add a new pivot I don't need to go through every slicer once again to link it.<br>
  2_ then I'd like to set all pivot caches to what I decide (Range("A1").CurrentRegion on <em>Data</em> seems pretty cool, otherwise I could reserve a cell on <em>Board</em> that I update manually).<br>
  3_ third and last, attach every slicer to every pivot table in the workbook.  </p>
  
  <p>Achievements:<br>
  1_ did it for 1 slicer, guess a loop will do the trick<br>
  2_ kinda did it, but...meh<br>
  3_ no way. I can't get this done.  </p>
  
  <p>Any suggestions?<br>
  Thank you for your help, this would be really a time saver!!  </p>