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

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