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
Bookmarks