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?

Select a cell in the pivot table
On the Pivot table toolbar, choose PivotTableShow Pages

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

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?

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