I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

It seems to work for me, but maybe not in the way the OP wants it. If I number
the cells in column A with the row number, then go to File / Page Setup / Sheet
/ Rows to repeat at top: and enter $12:$13, my printed pages show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202


Gord Dibben wrote:
You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

I see the same type of behaviour as Glen in Excel 2010 beta
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Glenn" wrote in message
...
It seems to work for me, but maybe not in the way the OP wants it. If I
number the cells in column A with the row number, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13, my printed pages
show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202


Gord Dibben wrote:
You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal
wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

It used to repeat just 12 and 13 and now all of a sudden
and I don't know why, it is repeating 1 - 13.

Same in 2003 and 2007

I misspoke.

Rows 12 and 13 won't appear as repeating on first page but will on each
successive page.

Right as always...............NOT! <g


Gord


On Tue, 6 Apr 2010 15:46:15 -0300, "Bernard Liengme"
wrote:

I see the same type of behaviour as Glen in Excel 2010 beta
best wishes

??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.

Opal wrote:
??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.

Make sure you have only this one worksheet selected, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13. When you print (or
Print Preview), what is the result?

the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29

Opal wrote:
the result is

Page 1

Rows 1 - 21

Page 2

Rows 1 - 9, 22-29



Makes no sense. If you want, and if the workbook is less than 1mb, email it to
me at schwandtg at aol dot com and I'll take a look at it.

Thanks, I wish I could, but the information in it
is proprietary. The only thing we were thinking
was maybe our IS Dept has failed to install
a Microsoft update..... :-(

I came up with a work around.

Utilizing the following placed in ThisWorkbook
from Ron DeBruin

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet 1" Then
Cancel = True
Application.EnableEvents = False
Application.ScreenUpdating = False
With ActiveSheet
.Rows("22:23").EntireRow.Hidden = False
.PrintOut
.Rows("22:23").EntireRow.Hidden = True
End With
Application.EnableEvents = True
Application.ScreenUpdating = True
End If
End Sub

I copied rows 12:13 to 22:23 where I need them
and used the above code. It works. The only issue
I will have is if the rows increase on page one of the
report I may have to adjust where I put 22:23.