Pagefield - select "(All)"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WayneR - 22 May 2008 18:39 GMT

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)"

Signature

WayneR

Reply to this Message

WayneR - 23 May 2008 20:21 GMT

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.....

Signature

WayneR

> Hi
>
[quoted text clipped - 16 lines]
>
> pvt.PageFields(1).CurrentPage = "(All)"

Reply to this Message