I have a pivot table that takes data from an OLAP cube - my problem is that
when a new project plan is added to the OLAP cube and I do a refresh on the
pivot table it includes the new plan - is there a way of stopping this and
only selecting the one field I have asked for. For example : I have selected
an entry from the drop down list of 518 and a new plan called ABC123 is added
to the cube when I do the refresh I only want 518 to be selected an no other
item.

Is there a way I can do this?

Thanks

Beverly Darvill;233930 Wrote:
I have a pivot table that takes data from an OLAP cube - my problem is
that
when a new project plan is added to the OLAP cube and I do a refresh on
the
pivot table it includes the new plan - is there a way of stopping this
and
only selecting the one field I have asked for. For example : I have
selected
an entry from the drop down list of 518 and a new plan called ABC123 is
added
to the cube when I do the refresh I only want 518 to be selected an no
other
item.

Is there a way I can do this?

Thanks

Didn't you already post this on Feb 12th in the Miscellaneous
questions?


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65294