Main Area and Open Discussion > General Software Discussion

Excel Printing Help

(1/1)

steeladept:
Okay folks, my Google-foo has failed me again and so I turn once again to you, the very knowledgeable DC community.  I have been trying for over a year now to print a monthly Excel report in duplex.  It is set up where each location is on a different worksheet, and I need to print the entire workbook.

Problem - When I print it out, even though I set it up as Entire Workbook and choose the duplex option, Excel sends each worksheet as a separate job.  If each worksheet is longer than 1 page, it duplexes it, but it will not duplex worksheets.

Current workaround is cumbersome, but does work. That is that I print to PDF, combine the worksheets into a single PDF, then print the PDF.  There has got to be a better way and I am looking to you to help me find it.  Anyone know it?

Navigation

[0] Message Index