title: How can I access selected report filter values in Excel Pivot table from VBA code or Formulas?
body: <p>I have a pivot table with report filter field. I need to do some operations based on the value user selects in report filter field. </p>
  
  <p>If user selects single value (or selects <code>All</code>) - no problem to get that value. In sample video it's cell B1, but in case of multiple values are selected, this field shows just <code>Multiple selected</code>.</p>
  
  <p>Where can I get the specific reporting filter values that are selected? Can I access those values from Excel formulas? If not - can I access those values from VBA code?</p>
  
  <p><a href="http://www.screencast.com/t/2cvWtSk6Ed1c" rel="nofollow">Sample video</a></p>