get Pivot table to generate separate worksheets for each row?
 

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.

??

get Pivot table to generate separate worksheets for each row?
 

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.
--
Regards

Roger Govier


"Matt D Francis" wrote in
message ...
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.

??

get Pivot table to generate separate worksheets for each row?
 

That's the fellow! Knew it was there somewhere.

Many thanks,

Matt

"Roger Govier" wrote:

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.
--
Regards

Roger Govier


"Matt D Francis" wrote in
message ...
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.

??