Print titles must be contiguous and complete rows or columns


M

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
 
Ad

Advertisements

M

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
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top