title: Is it possible to insert a slicer in an Excel 2010 pivot table that is connected to a SQL server database via an ODBC connection?
body: <p>The data source is connected via a connection string and command text as follows:</p>
  
  <pre><code>With objPivotCache
      .connection = "DRIVER=SQL Server;Integrated Security=SSPI;SERVER=Server035;WSID=;DATABASE=db_Warehouse"
      .CommandText = strSomeCommandString
  End With
  </code></pre>
  
  <p>The reason I ask is because when I try to insert slicers in the Options tab of the pivot table, the "Insert Slicer" option is grayed out.</p>