View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
BrianB BrianB is offline
external usenet poster
 
Posts: 109
Default Members in a PageField

A PivotField has PivotItems.

Regards
BrianB



(Rickard) wrote in message . com...
I want to create a customized report in Excel XP, in which I hide all
the filters (PageFields) in the Pivot table. I then want to use "my
own" Combo boxes to make the selection from. Is there a way to list
all the eg. Companies in PageField Company?

I have tried to use PivotItem, but a PageField doesn't seem to contain
any Pivotitems(?).

Thanks in advance,

Rickard