Excel 2016 printing b&w on a color printer


  • Any idea why Excel 2016 would print b&w on a color printer?  Is that a default setting?  All Windows Apps do it too, by the way (Photos, Edge...)

    • Edited by JS2010 Thursday, May 24, 2018 1:34 PM
    Thursday, May 24, 2018 1:29 PM

All replies

  • Hi,

    In general , you could choose it in print option.Did you update your printer driver to the latest version?

    Best Regards,


    Please remember to mark the replies as an answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Friday, May 25, 2018 6:32 AM
  • Are you using a Type 3 or a Type 4 driver?  Windows apps only produce XPS content so something may be getting lost when the spooler has to print these jobs two time for Type 3 drivers.

    If you are using a Type 4 driver then it could just be lack of color support in the Type 4 version of the driver.

    Alan Morris formerly with Windows Printing Team

    Wednesday, June 06, 2018 5:14 AM
  • It's type 3, Kyocera ECOSYS P7040cdn KX.  Papercut recommends against type 4 print drivers.  If I right click the printer and go to printer preferences, it will say "color: full color".  If I click Printer Properties in Excel in the Print area, it will say "color: black" in exactly the same dialog box (Excel on the left). 


    It only happens if I add the printer this way (powershell).  Maybe it doesn't update the devmode part of the user registry or something:

    add-printer -connectionname \\server\printer

    (which is really)

    $printclass = [wmiclass]'root\StandardCimv2:MSFT_Printer' 

    This way prints color ok from Excel (static method):

    $printclass = [wmiclass]'win32_printer'

    • Edited by JS2010 Friday, June 08, 2018 1:54 PM
    Thursday, June 07, 2018 5:48 PM
  • I'm wrong, both scripting methods don't work for Excel color printing.  But browsing to \\server and adding the printer with the mouse works.

    Monday, June 11, 2018 10:24 PM