Any help would be appreciated
Albion, I am experiencing the same problem on several users throuought the
group of companies that I work for. the printer used varies, but there are
three constants.
1./ The spreadsheet arrived via email (we use office 2003).
2./ If you print the spreadsheet to a printer other than your default, it
prints.
3./ If you change your default, it will then print to the printer it
originally failed to print to.
Patching to Office 2003 sp3 and running a detect and repair has fixed a few,
but not all. Hopefully Microsoft will pick up on this if enough of us note
the existence of the problem...
Thanks, K
Go to Excel Page Setup under the File menu item. Select the "Options"
button. On the Setup tab of the dialog that appears:
1) Job Type should read "Normal Print", not "Locked Print" or "Stored Print"
2) Uncheck the "Ignore application collate".
Changing those two settings also caused the Excel main dialog to change
"Print Quality" from blank to 600dpi which helped with our grey-shading.
Also on the Option buttion, we changed the Duplex option to "Open to top"
from "Open to Left" since this had been the default on our previous printer.
With that we could flip the pages up in front of us at meetings when there
was limited elbow room.
These options were all interacting with Excel. Excel will detect
significant changes in the print options of tabs (worksheets) and generate
independent print tasks causing a number of down-stream effects like extra
cover pages and intermittent duplex failures.
Thanks!