Is it possible to insert a slicer in an Excel 2010 pivot table that is connected to a SQL server database via an ADBC connection?
===

The data source is connected via a connection string and command text as follows:

    With objPivotCache
        .connection = "DRIVER=SQL Server;Integrated Security=SSPI;SERVER=Server035;WSID=;DATABASE=db_Warehouse"
        .CommandText = strSomeCommandString
    End With

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.