excel-2010

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 2007, 2009, and 2010; but not 2008 can the slicer list omit 2...

SQL & Excel 2010

Good morning, Does anyone know if there is an easy way I can use a SQL query in Excel to select specific data from an Excel spreadsheet without having to use VBA, Access, an SQL database or complicated Excel formula? Thank you very much. ...