Printing excel entire workbook

[aaalexxx]

hi guys,

i have this mpc6000 printing to excel worksheet.
when i print colour for the entire workbook. only the 1st page come out as colour. and the rest as black and white.
how you guys overcome this issue? possible to print out colour for all excel sheet at 1 go?

[KenB]

Welcome to Excel, my friend.

Excel has a nasty little habit of only applying your setting(s) to the first worksheet; all others will print with your printer default settings.

The easiest workaround is to set your preferences for the printer (in this case, set to color).

Just don't forget to set it back when you're done.

[aaalexxx]

thank u sir.

hopefully we got drivers that overcome this excel issue.
customer happy we less headache.

[aaalexxx]

customer not please with the reply.

i also shown her similar excel printing issue

Only first worksheet prints duplexed

O M G.

[Venom]

Perhaps try to print to document server, then print from there as you want

[KenB]

Why not install multiple copies of the same driver, but set the preferences on one of them to duplex, then rename the driver accordingly?

Good call on the Document Server. Although that would work, it does involve an extra step and more time.

Please make sure the customer is aware that this is Microsoft issue, and not a printer problem. We can't fix Microsoft problems, only try to work around them.

Perhaps other spreadsheet applications (Lotus 1-2-3, Open Office, etc..) don't have this problem.

[zyqwiz]

Try holding down the shift key then selecting then clicking on all the sheet tabs at the bottom. This will select all of them. Now set the page settings and it should apply what you set to all of them.