Excel will not print for some users after migration from a Windows 2003 print server to 2008

Posted on 2009-02-12
Last Modified: 2012-05-06
I have a select few uses who can't print from Excel after we migrated to a Windows Server 2008 Core printer server. All other applictions work just fine. This happens with a HP Laserjet 4240, Xerox 4500 and a Konica Minolta Color Bizhub 450.

I have tried about every possible print driver for each of these. I have tried new user profiles. Deleted Office Application Data from All Users. I have tried different printer quality settings within the drivers and on the printers. I have tried to copy and paste into new files. I have tried to mess with fonts and reinstalling fonts.

Some PC's can print these same Excel spreadsheets with no issues. The PC's that have no issues are using the same office update and the are all XP SP2.

I have no idea where to go from here.
Question by:MMHDU
    LVL 19

    Expert Comment

    what happens when you try to print?
    errors? nothing?
    does it matter who is trying to print? can the same people print from different computers?

    same version of excel? sp?

    Author Comment

    Sometimes when they try to print, the printer acts like it is going to start for a second and then it stops.
    No errors at all.
    It seems to be related to the PC and the user account.
    The same people can print from other PC's.
    Same Service Pack, same version of Excel.
    LVL 19

    Expert Comment

    it isn't the user account if the people can print on other machines (assuming roaming profiles)

    are there any errors in the even logs?


    Author Comment


    The clients show nothing in their event logs, but I filtered the logs on the Server 2008 Core Print Server and I found this in the logs:
    Log Name:      System
    Source:        Microsoft-Windows-PrintSpooler
    Date:          2/18/2009 7:46:03 AM
    Event ID:      6161
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          MINSTER\snappr
    Computer:      MinsterPS.MINSTER.COM
    The document 600399.XLS, owned by SnappR, failed to print on printer IS01_LJ. Try to print the document again, or restart the print spooler.
    Data type: NT EMF 1.008. Size of the spool file in bytes: 1093092. Number of bytes printed: 117391. Total number of pages in the document: 1. Number of pages printed: 0. Client computer: \\ Win32 error code returned by the print processor: 87. The parameter is incorrect.

    Event Xml:
    <Event xmlns="">
        <Provider Name="Microsoft-Windows-PrintSpooler" Guid="{e4c60dfa-ecc5-4889-b406-e9ddd38463c8}" EventSourceName="Print" />
        <EventID Qualifiers="49152">6161</EventID>
        <TimeCreated SystemTime="2009-02-18T12:46:03.000Z" />
        <Correlation />
        <Execution ProcessID="0" ThreadID="0" />
        <Security UserID="S-1-5-21-2110855865-1834110326-1341851483-2739" />
        <Data Name="param1">600399.XLS</Data>
        <Data Name="param2">SnappR</Data>
        <Data Name="param3">IS01_LJ</Data>
        <Data Name="param4">NT EMF 1.008</Data>
        <Data Name="param5">1093092</Data>
        <Data Name="param6">117391</Data>
        <Data Name="param7">1</Data>
        <Data Name="param8">0</Data>
        <Data Name="param9">\\</Data>
        <Data Name="param10">87</Data>
        <Data Name="param11">The parameter is incorrect.

    Accepted Solution

    I found that unticking the advanced printing option fix this issue. I just stumbled on this and tried it out. The issue id resolved.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    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…

    731 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now