Error with print titles not being contiguous

S

Steve_O

I have grouped worksheets that I need to print as a book with page numbers.
Most of the worksheets do not use the Titles feature for repeating rows /
columns since they are different reports that fit to one page. When I try to
print the book I get the message "print titles not contigous" even though
those fields are blank and Excel crashes and closes. When it recovers the
file all the print features for size and footers have been reset and I need
to fix every page.

When I select each sheet and get the error message I can select "titles" and
it brings up the dialog box with it being blank except for the print range
and I can hit the print preview button and it works without me doing
anything. However, if I have not done that with every sheet, back to the big
error and crash.

Why does Excel say there is an error when it doesn't exist.
 
J

John Robinson

Go to Page Layout Tab
Print Titles Button
Sheet Tab......

Clear out the Print Area Field

For some reason Mr. Excel does not like anything in that field.





Steve_O wrote:

Error with print titles not being contiguous
14-Sep-09

I have grouped worksheets that I need to print as a book with page numbers
Most of the worksheets do not use the Titles feature for repeating rows
columns since they are different reports that fit to one page. When I try t
print the book I get the message "print titles not contigous" even thoug
those fields are blank and Excel crashes and closes. When it recovers th
file all the print features for size and footers have been reset and I nee
to fix every page

When I select each sheet and get the error message I can select "titles" an
it brings up the dialog box with it being blank except for the print rang
and I can hit the print preview button and it works without me doin
anything. However, if I have not done that with every sheet, back to the bi
error and crash

Why does Excel say there is an error when it does not exist.

Previous Posts In This Thread:

Error with print titles not being contiguous
I have grouped worksheets that I need to print as a book with page numbers
Most of the worksheets do not use the Titles feature for repeating rows
columns since they are different reports that fit to one page. When I try t
print the book I get the message "print titles not contigous" even thoug
those fields are blank and Excel crashes and closes. When it recovers th
file all the print features for size and footers have been reset and I nee
to fix every page

When I select each sheet and get the error message I can select "titles" an
it brings up the dialog box with it being blank except for the print rang
and I can hit the print preview button and it works without me doin
anything. However, if I have not done that with every sheet, back to the bi
error and crash

Why does Excel say there is an error when it does not exist.

EggHeadCafe - Software Developer Portal of Choice
Play Embedded Sound Resources in .NET
http://www.eggheadcafe.com/tutorial...5-712cc8b24106/play-embedded-sound-resou.aspx
 

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