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 / November 2003

Tip: Looking for answers? Try searching our database.

Excel Splitting Single Print Job Into Multiple Jobs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Luis Correia - 24 Nov 2003 13:59 GMT
Has anyone experienced a problem with excel (Office 2000 SP3)
whereby, for no appearent reason, what should be a single print job is
split
into multiple jobs...

i.e. selecting multiple sheets (a subset of the entire workbook) and
hitting print..

The problem occurs with different printers and printer drivers.
The problem also occurs in various spreadsheets.

A workaround we have discovered is that if you copy+paste the data
into a brand new spreadhsheet - the problem disappears..

The workaround is fine for small spreadhseets - however, we have
spreadsheets
of 50MB+ that this technique does not work for (we get 'Out of memory'
errors)...

Also, we are concerned about the integrity of the copy... i.e. that
links / references / formulas / named areas etc...  get copied
properly without damage..
Darren - 25 Nov 2003 00:12 GMT
I have exactly that problem (with the Office XP SP2 version).  I have
been trying to fax 2 worksheets of a workbook (and/or a whole workbook
with only 2 sheets) and it refuses to send more than 1 page per fax
(not including coversheets, usually).  I'll try to use the workaround
you suggested in the future, thanks

> Has anyone experienced a problem with excel (Office 2000 SP3)
> whereby, for no appearent reason, what should be a single print job is
[quoted text clipped - 18 lines]
> links / references / formulas / named areas etc...  get copied
> properly without damage..
Luis Correia - 30 Nov 2003 13:44 GMT
The Solution:

Straight from Microsoft - This is a known issue. The behaviour is by design.
The reason the sheets are split into multiple print jobs is because
the sheets are of varying print quality....

Every time the print quality changes - a new print job is started...
Set all sheets to be printed to the SAME quality (say 600 dpi) - problem solved....

> I have exactly that problem (with the Office XP SP2 version).  I have
> been trying to fax 2 worksheets of a workbook (and/or a whole workbook
[quoted text clipped - 24 lines]
> > links / references / formulas / named areas etc...  get copied
> > properly without damage..

Rate this thread:






 
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.