Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PT - list multiple page field selections
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow for multiple selections from a list | Excel Worksheet Functions | |||
Printing Multiple Selections on one page | Excel Programming | |||
Remove old selections in Pivottable row field dropdown list | Excel Programming | |||
How do I get "multiple selections" displayed in Pivot Table Field | Setting up and Configuration of Excel | |||
List box with multiple selections | Excel Programming |