You're welcome. If it's something you do frequently, you could add the
Show Pages button to the Pivot Table toolbar, so it's easier to access.

Ekazakoff wrote:
Thanks Debra, for some reason I never use that toolbar. It seems like that
functionality should be a right click on the item in the page field. Oh
well. Thanks again for pointing me in the right direction.
"Ekazakoff" wrote:


I have created a pivot table report and I have chosen to have a page field.
Instead of looking at one result at a time I know there is a way to get each
page of the report shown on its own worksheet. I have done this in the past
but cannot remember how to do it or find instructions on how to do it. Can
someone help?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html