visibletemslist for excel 2007

[varsha12]

Hi,
When i open excel 2007 in compatibility mode the visibleitemslist shows
an application error. I have a filter with multiple items selected in my
pivot table. How can i get these values for excel 2007 in compatibility mode.

 

[Bob Phillips]

Are you referring to a PageField?

What is the pivot connected to, Excel, SQL Server, a cube?

HTH

Bob

 

[varsha12]

Yes i am referring to a PageField. It is connected to a cube.

 

[Bob Phillips]

I have had many issues when trying to access properties of a Pagefield
against an AS cube.

I have found that if the PageField refers to a drilldown, i.e. a multi-level
cubefield, and the filtered selection is multiple items from multiple
levels, then the VisibleItemsList doesn't show every item selected.

I guess the real question is, why do you need this data? In my case, I was
trying to do a drill-through on the selection, and I gave up if multiple
items were selected.

HTH

Bob