Repeat Pivot Row on when printing

[tommcbrny]

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]

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