Double-click the Department field button.
In the PivotTable field dialog box, click the Layout button
Add a check mark to 'Insert page break after each item'
Click OK, click OK
To see the headings on each page:
Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to 'Set print titles'
Click OK
Fred wrote:
I am creating a pivot table that has as its primary break a department
number, with lots of details properly summarized under it. Each
department with a differnt length report.
Is there a way to automatically enter Page Breaks so that each
department prints on a separate page?
Thanks in advance,
Fred in NY
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html