PT - list multiple page field selections

R

rachael

I have a pivot table based off of a cube. One of the page filters has
multiple selections. Whenever new values are added to that field in the cube,
they are automatically selected in the page field when the PT is refreshed.
This is something i *don't* want. I'd like to run a macro that quickly checks
to see what's selected in the page field and either automatically change it
to what i want (if new values were selected) or just list somewhere which
values were selected so I can easily scan the list and change the pivot table
if necessary.

I've seen help for single selections in a page field (e.g.,
CurrentPage.Name), but haven't seen anything for multiple selections. Can
this be done?

Thanks,
rachael
 

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

VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0
list or combo box 0
Storing Multiple Selected Pivot Table Report Filter Values 2
linking pivot table selections 2
How Do I Change Two Pivot Table Page Selections with VBA Code 1
FRom Pivot table select multiple items under report filter 0
Apply multiple filters from list 0
How to Update Selections for (Numerous) Validation Lists 1

Top