Refresh CubeFields for existing Pivot Table on OLAP cube

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing OLAP Pivot Table Connection Source 0
Change the data source of a pivot table 1
OLAP Pivot Table 1
Local cube path to database 1
Pivot Table question 1
OLAP Cube for Excel 97? 1
Pivot table on local cube 1
local cube files 1

Top