| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Linear Mode
