visibletemslist for excel 2007

  • Thread starter Thread starter varsha12
  • Start date Start date
V

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.
 
Are you referring to a PageField?

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

HTH

Bob
 
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
 
Back
Top