Any way to hide Slicer Values in Excel 2010

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 20开发者_开发知识库07, 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.

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"

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!

This feature does not exist. But an alternative does exist. Place the slicer anywhere in another sheet and hide that sheet and it will still work.

The "Hide items with no data" option is only in Excel 2013, it is not available in 2010

You cannot do this in Excel; the feature doesn't exist. You may find that page filters will suit the task better.