Excel Printing Issues
Last modified on 14 August 2020 10:49 AM
Printing multiple copies of Excel Workbooks causes multiple print jobs
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.
This has two implications for users of PaperCut:
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:
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.
You can read more information about this issue at Microsoft Knowledgebase Article Q211474.