The Print Spooler & PDF

[Guest]

I have the need to convert large multi-page spreadsheets to a PDF file. To do this I have a print driver that you send the document to just as though you were going to print it. It coverts it to a PDF file. This great so far. My problem is this: Sometimes Excel sends a file as more than one print job. To a printer this is no problem because it just prints them out in sequence and you have your document. The PDF writer, on the other hand, sees more than one print job and creats more than one file. I need it to be one file. Is there a way to force excel to send it as only one print job?

 

[Lady Layla]

HAve never seen Excel do this. Can you be more explicite as your print setup
that causes multi print jobs


: I have the need to convert large multi-page spreadsheets to a PDF file. To do
this I have a print driver that you send the document to just as though you were
going to print it. It coverts it to a PDF file. This great so far. My problem
is this: Sometimes Excel sends a file as more than one print job. To a printer
this is no problem because it just prints them out in sequence and you have your
document. The PDF writer, on the other hand, sees more than one print job and
creats more than one file. I need it to be one file. Is there a way to force
excel to send it as only one print job?

 

[Guest]

I am not sure if I can be more specific about my print setup because it seems to be a random thing. I have a spreadsheet template that I use for my work. The print settings are set in the template and each new job is just a save-as file. There is nothing special about the print settings. Each sheet of the workbook is a seperate page. There is a header and a footer on each page. When I am ready to print, I just group the sheets I want printed and go for it. Because it is a template, I don't always use all of the sheets in a specific job and the sheets I do use are not always consecutive. This does not seem to matter when printing to a printer. They always come out fine with correct page numbers and such. In fact the PDF file always has the correct fromatting and headers and footers. They are just in more than one file. The reason I say it's random is that I can print a job to the PDF driver and it works great and is all in one file, then print the same job to the same driver with no changes to the setup 15 minutes later and it creates 2 or three files. I am stumped. I have tried to change some of the settings in the properties of the PDF writer to no avail.