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.
dustbort - 04 Mar 2008 16:22 GMT
Never mind, Refresh Data does work.
> 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
[quoted text clipped - 4 lines]
>
> Thank you.