Repeat Pivot Row on when printing
 

Hi, I have an Excel 2007 pivot table laid out in Compact Form. The first
field in Row Labels, a name, contains several pages of data beneath. Is
there a way for me to print this name on each page of the printout until the
next name appears?

I have selected to page break after each item in this field, this works
well. I now want to have the field value repeated at the top of each page
unitl the next name appears if possible.

Thank you,
Tom

Repeat Pivot Row on when printing
 

The Repeat Row Labels on Each Printed Page setting only has an effect if
the pivot table is in Tabular Form or Outline Form.

tommcbrny wrote:
Hi, I have an Excel 2007 pivot table laid out in Compact Form. The first
field in Row Labels, a name, contains several pages of data beneath. Is
there a way for me to print this name on each page of the printout until the
next name appears?

I have selected to page break after each item in this field, this works
well. I now want to have the field value repeated at the top of each page
unitl the next name appears if possible.

Thank you,
Tom


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com