Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can drag the page field temporarily to the Row area, select the
items you want, then drag it back to the Page area. Or, double-click on the Page field button, and in the Hide Items list, click on items to hide. Click on hidden items to show them again. Sharon wrote: Hi Sorry about coming back again, but I have a question about page fields. Is it possible to make a multiple selection from a page field? And if so, can it be done programatically? I know it can be done if the pivot is based on an OLAP cube but it would be great if it could be done with a pivot based on a data range. Any help would be really welcome. Thanks -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivots/Charts | Charts and Charting in Excel | |||
several pivots | Excel Discussion (Misc queries) | |||
Pivots | Excel Programming | |||
I would like to build macro's to do pivots or part of pivots | Excel Programming | |||
Pivots using other pivots and dynamic query problem | Excel Programming |