Excel Printing Issues

KB Home   |   Excel Printing Issues

Main.ExcelPrintingIssues History

Hide minor edits - Show changes to output

Added lines 18-20:
!!! Option 2
A customer in Dec 2013 reported that selecting "Fit sheet on one page" on a multi-sheet Excel document changed Excel's behaviour such that it printed with one spool file rather than the 6 it normally used for that document. This might be a solution for some Excel documents.

January 10, 2011, at 11:08 PM by peter - fixed some minor grammatical inconistencies
Changed lines 5-6 from:
When you print multiple copies of an Excel workbook, Microsoft Excel creates separate print job for each copy, and then sends the jobs to the printer.  So if you print 5 copies of an Excel workbook, five identical print jobs are created and sent to the printer.  This behaviour is different to that of other Microsoft and Windows applications.
to:
When you print multiple copies of an Excel workbook, Microsoft Excel creates a separate print job for each copy, and then sends the jobs to the printer.  So if you print 5 copies of an Excel workbook, 5 identical print jobs are created and sent to the printer.  This behaviour is different to that of other Microsoft and Windows applications.
Changed lines 9-10 from:
# PaperCut users using either the PaperCut NG or PaperCut ChargeBack popup client will be prompted to allocate each print job to an account.  So printing 5 copies will result in the client requesting the user to allocate 5 individual jobs.  Both PaperCut NG and PaperCut ChargeBack offer an option to '''Apply to all jobs in the queue'''.  Selecting this option will assign the selection to all jobs avoiding the need to deal with a popup for each job.
to:
# PaperCut users using either the PaperCut NG or PaperCut ChargeBack popup client will be prompted to allocate each print job to an account.  So printing 5 copies will result in the popup client requesting the user to allocate 5 individual jobs.  Both PaperCut NG and PaperCut ChargeBack offer an option to '''Apply to all jobs in the queue'''.  Selecting this option will assign the selection to all jobs avoiding the need to deal with a popup for each job.
October 01, 2009, at 12:09 PM by 218.214.136.115 -
Changed line 14 from:
The Microsoft article below states that you can stop Excel submitting multiple jobs by deselecting the "Collate" checkbox when you print.  However the downside of this approach are:
to:
One option is to upgrade to the latest version of Office.  Microsoft has addressed this strange multiple-copies printing behavior in recent versions.  For older versions, the Microsoft article below states that you can stop Excel submitting multiple jobs by deselecting the "Collate" checkbox when you print.  However the downside of this approach are:
Changed lines 19-21 from:
You can read more information about this issue at Microsoft Knowledgebase Article Q211474. (http://support.microsoft.com/default.aspx?scid=kb;en-us;211474)
to:
You can read more information about this issue at Microsoft Knowledgebase Article Q211474.

(http://support.microsoft.com/default.aspx?scid=kb;en-us;211474)
Added lines 1-2:
(:title Excel Printing Issues :)
Changed line 5 from:
This has 2 implications for users of PaperCut:
to:
This has two implications for users of PaperCut:
Changed line 7 from:
# PaperCut users using either the PaperCut NG or PaperCut ChargeBack popup client will be prompted to allocate each print job to an account.  So printing 5 copies will result in the client requesting the user to allocate 5 individual jobs.  (Note: The PaperCut ChargeBack 5.0 client allows the users to "assign account to all jobs in queue", so they will only need to assign the job once, and all remaining jobs in the queue will be assigned to that account.)
to:
# PaperCut users using either the PaperCut NG or PaperCut ChargeBack popup client will be prompted to allocate each print job to an account.  So printing 5 copies will result in the client requesting the user to allocate 5 individual jobs.  Both PaperCut NG and PaperCut ChargeBack offer an option to '''Apply to all jobs in the queue'''.  Selecting this option will assign the selection to all jobs avoiding the need to deal with a popup for each job.
Changed line 7 from:
# PaperCut Chargeback users will be prompted to allocate each print job to an account.  So printing 5 copies will result in the PaperCut Chargeback client requesting the user to allocate 5 individual jobs.  The PaperCut ChargeBack 5.0 client allows the users to "assign account to all jobs in queue", so they will only need to assign the job once, and all remaining jobs in the queue will be assigned to that account.
to:
# PaperCut users using either the PaperCut NG or PaperCut ChargeBack popup client will be prompted to allocate each print job to an account.  So printing 5 copies will result in the client requesting the user to allocate 5 individual jobs.  (Note: The PaperCut ChargeBack 5.0 client allows the users to "assign account to all jobs in queue", so they will only need to assign the job once, and all remaining jobs in the queue will be assigned to that account.)
Changed line 3 from:
When you print multiple copies of an Excel workbook, Microsoft Excel creates separate print job for each copy, and then sends the jobs to the printer.  So if you print 5 copies of an Excel workbook, five identical print jobs are created and sent to the printer.
to:
When you print multiple copies of an Excel workbook, Microsoft Excel creates separate print job for each copy, and then sends the jobs to the printer.  So if you print 5 copies of an Excel workbook, five identical print jobs are created and sent to the printer.  This behaviour is different to that of other Microsoft and Windows applications.
Changed line 5 from:
This has 2 implications for users of PaperCut users:
to:
This has 2 implications for users of PaperCut:
Changed lines 1-17 from:
Describe ExcelPrintingIssues here.
to:
!! Printing multiple copies of Excel Workbooks causes multiple print jobs

When you print multiple copies of an Excel workbook, Microsoft Excel creates separate print job for each copy, and then sends the jobs to the printer
.  So if you print 5 copies of an Excel workbook, five identical print jobs are created and sent to the printer.

This has 2 implications for users of PaperCut users:

# PaperCut Chargeback users will be prompted to allocate each print job to an account.  So printing 5 copies will result in the PaperCut Chargeback client requesting the user to allocate 5 individual jobs.  The PaperCut ChargeBack 5.0 client allows the users to "assign account to all jobs in queue", so they will only need to assign the job once, and all remaining jobs in the queue will be assigned to that account.

# If you have the "Deny duplicate print jobs submitted within" option enabled, PaperCut will release the first copy for printing, but will deny subsequent copies because the subsequent print jobs are identical to the first. 

!!! Workaround
The Microsoft article below states that you can stop Excel submitting multiple jobs by deselecting the "Collate" checkbox when you print.  However the downside of this approach are:
* You need to manually collate the pages of the printed workbook
* Users need to remember to deselect the option every time they print multiple copies of Excel documents.

!!! More Information
You can read more information about this issue at Microsoft Knowledgebase Article Q211474. (http://support.microsoft.com/default.aspx?scid=kb;en-us;211474)

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on December 19, 2013, at 03:55 AM
Printable View   |   Article History   |   Edit Article