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
 

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

Excel 2007 VBA - macro stops after autofilter command 6
Excel SaveAs to force overwrite of extant file 1
Application Name differences between Excel 2003 and 2007 3
HELP radio button not functioning in Excel 2007 1
Avoiding Compile Error for Unsupported Methods 2
Pagefield - select "(All)" 1
Certificate breaks when file is saved 4
Corrupt files due to pivot remnants after saving via VBA 0

Back
Top