title: Can I Automatically Select Slicer Options?
body: <p>I am working on an Excel workbook that contains large amounts of entries in one large table, all the entries are sorted by date. I have inserted a slider for easier viewing of the data by month, but now what I want to do is have the slider options automatically selected.   </p>
  
  <p>Eg.  </p>
  
  <p>One of my worksheets is designed to show a month summary, all of the totals and such are calculated with a SUMIF based on the date so that only the current month's data is totaled, now on that worksheet i also want to include a slicer with all that months entries, Easy enough, but i want the current month automatically selected, it will confuse people if after selecting monthly statement they receive most of the info automatically but then have to select the month they are after for the other parts of the statement. So what i want is a way to make the slicer default to a value set in another cell.</p>