Good Afternoon,

I am attempting to use a control box to control two OLAP pivot tables, however I am running into an error, "Unable to set the CurrentPage property of the PivotField class." Can a combo box control an OLAP pivot table? If so, what am I missing?


  ActiveSheet.PivotTables("FTE Current vs PY").PivotFields( _
        "[Course Term].[Term].[Term]").ClearAllFilters
    ActiveSheet.PivotTables("FTE Current vs PY").PivotFields( _
        "[Course Term].[Term].[Term]").CurrentPage = ActiveSheet.Range("O24").Value
Thanks