Try it and tell us.

--
Regards,
Tom Ogilvy

"Polly" wrote in message
...
I am using OLAP cube to create the pivot table.
Will OLAP affect the result?

Best Wishes,
Polly


-----Original Message-----
Thanks for William's and Debra's reply.

I have tried both of your suggestions. However, your
codes did not work in my pivot table. If I
change "pagefields" to "rowfields" in the programs, they
both worked! I mean it can show the details of row
field.
I have put a dimension in page field area and selected
five items in the dimension. Does the program not work
due to mulit-selection of items?

Best Wishes,
Polly



-----Original Message-----
Does anybody know how to get the item name in the
pagefields? It seems that the following expression
doesn't work.

..PivotFields("[PageField Name]").PivotItems(i).Name
where i=1,2,3,...

Can someone give me some suggestions?

Thanks!

Best Wishes,
Polly
.

.