get Pivot table to generate separate worksheets for each row?

M

Matt D Francis

I could be losing my mind, but isn't there a function where you can get a
Pivot Table to create a separate worksheet for each row in your table - in
one go. I know I can do it by double-clicking the total but i thought there
was a single function to do them all in one go? I'm using 2003 btw. For
example if my Pivot happened to contain seven rows - one for ecah day of the
week, I could get that to create seven worksheets in my workbook labelled
Monday, Tuesday etc.

??
 
R

Roger Govier

Hi Matt

That only works for a field one has added to the Page area of the PT.
If Days was added to the Page area, it would default to All, but the
drop down would show the 7 individual days.

Then, from the dropdown on the PT toolbar, select Show pages and it will
create a single sheet for each item in the Page field.
 
Top