Hi All

I absolutely agree that Debra's way is really easy to do manually. However,
I needed to do it programatically so I have found that hiding unwanted items
is easier from a coding perspective.

Many thanks to you all for your help (again!!)
--
Sharon


"Excelenator" wrote:


I'm not sure about programatically doing this but there is a manual way
to do this. If you drag your page field down to the rows section as
the first field you can click the select arrow, check or uncheck the
items you want or don't want and then drag the field back up to the
page section. The pivot will now be based on your multiple
selections.


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


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566060