How do I create multiple worksheets from Page Pivots

I have created a pivot table, and I have a Year as the "page" pivot. I would
like to have all the years show up as separate worksheets rather than having
to change the Page pivot. I know that this is possible, I have seen it done,
but I can't seem to remember hoiw this is done... Help!

Vinay

Select a cell in the pivot table
From the pivot toolbar, choose PivotTable > Show Pages
Select a page field in the list, and click OK

Vinay wrote:
> I have created a pivot table, and I have a Year as the "page" pivot. I would
> like to have all the years show up as separate worksheets rather than having
> to change the Page pivot. I know that this is possible, I have seen it done,
> but I can't seem to remember hoiw this is done... Help!
>
> Vinay
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks, Debra...

Vinay

"Debra Dalgleish" wrote:

> Select a cell in the pivot table
> From the pivot toolbar, choose PivotTable > Show Pages
> Select a page field in the list, and click OK
>
> Vinay wrote:
> > I have created a pivot table, and I have a Year as the "page" pivot. I would
> > like to have all the years show up as separate worksheets rather than having
> > to change the Page pivot. I know that this is possible, I have seen it done,
> > but I can't seem to remember hoiw this is done... Help!
> >
> > Vinay
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>