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