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..