Excel Printing Problems

Posted on 2011-02-24
Medium Priority
Last Modified: 2012-05-11
Hi guys
When the staff here print from a MS Excel 2003 spreadsheet with multiple worksheets the first worksheet will print in colour as requested but the rest of the worksheets will only print in bkacl and white. We are using a HP LaserJet 9500 MFP and it has the latest drivers. Have uninstalled and reinstalled the drivers but no difference. Even if we print locallly or through the print server there is no difference. Is there an option that im missing somewhere or any other ideas?
Question by:P3admin
LVL 50
ID: 34975535

click Files > page setup > Sheet tab and make sure "black and white" is not ticked.

This can be set for individual sheets.

cheers, teylyn
LVL 22

Expert Comment

ID: 34975540
Is the printer default set to B&W?
Not sure, but I think each worksheet has independent print settings so if you changed only the first obe color, the rest are still B&W.  But if you go to Windows and change the default print settings to color, then the rest might show up as color.
LVL 32

Accepted Solution

Rodney Barnhardt earned 2000 total points
ID: 34980018
I have ran into this before. The problem with printing an entire workbook is that MS Office treats each sheet in a workbook as a seperate print job. There is no way to change this andif you are using a printer that defaults to B&W, you need to create a seperate printer that defaults to color for those people who need to print color workbooks. I went round with MS on this a while back.

This is also explained on a Google MS Office group site:"This is because Excel flushes all print-job specific settings between
sheets, even when in a group selection.  This is evidenced in another
way that users of Adobe Acrobat will know.  If you select a group of
sheets and print to PDFWriter, you get asked for a filename for each
SHEET (not just for one filename and then it prints all sheets to that
same file).  Therefore, each sheet is being sent as a separate job,
just that Excel automatically sends all the jobs at once when in a
group selection.

However, there is no way to stop the Printer Preferences getting in the
way between the jobs - so whatever you have set over and above that in
Properties will only hold for the first sheet in the selection.

It's not a bug as such because that's what you would expect to happen
if printing the sheets separately anyway; it's just that Microsoft have
obviously never got around to making group selections spool to print as
if they were one job - probaby because there are too many counters,
pointers, indexes and handles calculated and incremented whilst
rendering one worksheet to the spooler to allow other worksheets to
follow on in the same job.  Probably too demanding memory and resources
wise. "


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question