Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / June 2007

Tip: Looking for answers? Try searching our database.

Sheets break into multiple print jobs?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
znelson - 07 Jun 2007 15:36 GMT
We're running into an issue printing our workbook. The sheets do not
print as 1 print job, rather they're broken into smaller jobs of 4-10
sheets each. This creates havoc with the page numbering (eg. Page X of
Y).

The interesting part is that it always breaks between the same
specific sheets each time, and the breaking occurs between logical
breaks in sections throughout the book. In other words we have
something like this:

Logical grouping of sheets called "North America"
Sheet1
Sheet2
Sheet3

Logical grouping of sheets called "South America"
Sheet4
Sheet5

When printing it breaks between those groups and sends each as a
seperate print job. We can't figure out where this is defined or
what's causing it. Any ideas? Thanks in advance!
znelson - 07 Jun 2007 15:46 GMT
Found the problem, not all sheets were set up with the same print DPI.
Fixed it by going to Page Setup on each sheet and setting it to 300DPI.
Gord Dibben - 07 Jun 2007 16:19 GMT
Thanks for posting the fix.

Not a common problem.

May come in handy at some point.

Gord Dibben  MS Excel MVP

>Found the problem, not all sheets were set up with the same print DPI.
>Fixed it by going to Page Setup on each sheet and setting it to 300DPI.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.