| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pagefield - select "(All)"
Hi
I have 2 differnt fields for my page - I want to set one to a user enter value and the other to "ALL" items. I have tried the following pvt.PivotCache.Refresh pvt.PivotFields(str_selection_value1).CurrentPage = str_selection pvt.PivotFields(str_selection_value2).CurrentPage = "(All)" The pivot table seems to be suing a value of "(All)" , selecting nothing since there is no "(All)" value, instead of selecting all items. Is there an XLPageFieldsAll constant, I can use. Also, I am using XL 2007 - the sheet is in compatibility mode, some users ahve 2007 some 2003. Thanks Wayne pvt.PageFields(1).CurrentPage = "(All)" -- WayneR |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pagefield - select "(All)"
I found my problem -- I don't know if this is just for files saved in 97-2203
compatible mode or not.. What I had to do was remove the "slect multiple" from the pagefiled... it worked fine after that..... -- WayneR "WayneR" wrote: Hi I have 2 differnt fields for my page - I want to set one to a user enter value and the other to "ALL" items. I have tried the following pvt.PivotCache.Refresh pvt.PivotFields(str_selection_value1).CurrentPage = str_selection pvt.PivotFields(str_selection_value2).CurrentPage = "(All)" The pivot table seems to be suing a value of "(All)" , selecting nothing since there is no "(All)" value, instead of selecting all items. Is there an XLPageFieldsAll constant, I can use. Also, I am using XL 2007 - the sheet is in compatibility mode, some users ahve 2007 some 2003. Thanks Wayne pvt.PageFields(1).CurrentPage = "(All)" -- WayneR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
| Loop through PivotItems of PageField - including "(All)" | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Linear Mode
