Pagefield - select "(All)"

  • Thread starter Thread starter WayneR
  • Start date Start date
W

WayneR

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

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

Set Pivot Table Pages 1
Pivot Multi Page Diff Change 2
Using macro to switch 'page' in a pivot table? 1
Updating pivot items on 3 pivot tables contained on one sheet 2
RunTime Error 1004? _Default Property? 4
delete selection in pivotcolumn 3
update pivot fields VBA 1
linking pivot table selections 2

Back
Top