ExcelBanter - Excel printing to separate files

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Excel printing to separate files (https://www.excelbanter.com/setting-up-configuration-excel/146643-excel-printing-separate-files.html)

Glenn Allan

Excel printing to separate files

We have several Excel spreadsheets that we print to PDF, several of the PDFs
print some sets of sheets to a separate file, a spreadsheet may have 15
sheets, in some cases it will print the first sheet to one file then the next
7 to another file when printing the entire workbook.

How can we fix this so that the workbook prints to a single file

All times are GMT +1. The time now is 11:25 PM.