Excel 2007 - display pivot table filter values


  • I have a pivot table in Excel 2007.  The pivot table uses a multi select filter. When more than one value is selected, it displays "(Multiple Items)".  I need todisplay the actual values that are selected in a different cell.   Is there some sort of function I can use to display those values.
    Tuesday, June 12, 2012 6:43 PM


All replies

  • Excel 2007/2010 Tables, PivotTable
    List all visible PageField Items.
    With macro.

    If you get *.zip, don't unzip, just rename *.xlsm

    Wednesday, June 13, 2012 10:20 PM
  • Great solution.  I had developed a template in Excel 2010 that used some VBA code that interrogated some slicers to produce a title for a pivot chart.  Come to find out some of our clients are only running Excel 2007 and therefore slicers are not an option.  I was looking for another way to show what data was being shown on the pivot chart but that was compatible with Excel 2007.  Your solution fit the bill and is quite elegant.


    Thursday, October 31, 2013 1:14 PM