Refresh CubeFields for existing Pivot Table on OLAP cube

  • Thread starter Thread starter dustbort
  • Start date Start date
D

dustbort

We are using Excel 2002. I have a pivot table with an OLAP cube data
source. I have added a new member to the cube and would like to be able to
add the member to the pivot table as a data field, but the member does not
appear in the PivotTable Field List. Using Refresh Data does not work. Is
there a way, either through the GUI or through VBA to refresh the field list
to show the new member?

Thank you.
 
Back
Top