visibletemslist for excel 2007
 

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.

visibletemslist for excel 2007
 

Are you referring to a PageField?

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

HTH

Bob

"varsha12" wrote in message
...
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.

visibletemslist for excel 2007
 

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

"Bob Phillips" wrote:

Are you referring to a PageField?

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

HTH

Bob

"varsha12" wrote in message
...
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.


.

visibletemslist for excel 2007
 

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


"varsha12" wrote in message
...
Yes i am referring to a PageField. It is connected to a cube.

"Bob Phillips" wrote:

Are you referring to a PageField?

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

HTH

Bob

"varsha12" wrote in message
...
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.


.