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.

??