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.