Print titles must be contiguous and complete rows or columns

[Michelle]

I have a workbook in which I need to print all the pages, with continuous
page numbering...

I can usually select all sheets and print them, but I have some workbooks
that won't even go into print-preview, and get the following error message:

'Print titles must be contiguous and complete rows or columns'

I know that this can be because of incorrect entries in 'Rows to repeat at
top', or 'Columns to repeat at left' but none of my sheets have anything at
all in either box.

I believe that it can also be because of embedded objects with the wrong
print settings, but none of my sheets contain any objects.

What other reason might I be getting this error?

Any ideas?

Thanks

M

 

[JLGWhiz]

Maybe merged cells, either vertically or horizontally.

 

[Michelle]

Thanks, but there are no merged cells either...

I did discover that if I'm on one of the sheets with a problem, and I go to
File>PageSetup, and select print preview from there (having made no
changes), that it goes into preview no problem, and prints ok. but If I go
into File>Page Setup and then close the box, and try print preview from the
toolbar, then I get the error message - weird?

Once I've done that, it will then go into preview and print OK - it all
works fine, but I need to do that on every sheet with the problem, EVERY
time this workbook is created.

Any idea what I'm doing wrong, so I can stop it?

Thanks

M

 

[JLGWhiz]

My very limited expertise in solving printing problems precludes a surefire
solution, but perhaps things like Headers and Footers, manual page breaks or
anything that cause a problem for the printer in calculating the page
parmeters. The big question is what is different about the sheet that the
printer balks on from the other sheets? It must be something that is not
obvious to the causual observer.