title: Any way to hide Slicer Values in Excel 2010
body: <p>I know that Excel 2010 Slicers will visually indicate when there is no data associated with a particular slicer selection. For example, they are faded in color for 2010 if you have no values in 2010.</p>
  
  <p>Is there some setting where I can hide them altogether? </p>
  
  <p>If I have sales in 2007, 2009, and 2010; but not 2008 can the slicer list omit 2008 entirely or must it always be shown as greyed out. </p>
  
  <p>I'm not asking for a SQL selection solution, but rather an Excel setting. </p>