Any way to hide Slicer Values in Excel 2010

Question

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.

Is there some setting where I can hide them altogether?

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.

I'm not asking for a SQL selection solution, but rather an Excel setting.

Answer 1

Actually, yes you can! If the item on the slicer is grayed out because there is no data, you can do the following:

Right click anywhere on the slicer and select "Slicer Settings" from the drop down.

On the bottom right select the box that says "Hide Items with no Data".

Click "OK"

Answer 2

Found a way of mimicing this in 2010 - see this article on formatting Slicers

http://datapigtechnologies.com/blog/index.php/getting-fancy-with-your-excel-slicers/

Create a custom format, and just set the items with no data to white fill & White text, and they dissapear! You should also set the "hover over" for items with no data to the same, otherwise they will appear if the user hovers ofer the item. Simples. Thanks to Datapig!