http://www.dopdf.com/forum/ doPDF does PDF. For FREE. en Sat, 21 Nov 2009 02:43:40 +0000 http://www.dopdf.com/forum/topic/pdf-will-not-print-or-convert-all-of-excel-sheets-as-one#post-570 Thu, 05 Feb 2009 07:22:46 +0000 Softland 570@http://www.dopdf.com/forum/ <p>Hi Les, this is how Excel handles the printing if there is a different printing quality for each sheet. See this article for a workaround (even if it's for novaPDF it applies to doPDF too): <a href="http://www.novapdf.com/kb/printing-an-entire-excel-workbook-to-a-single-pdf-file-135.html">Printing an entire Excel workbook to a single PDF file</a> </p> http://www.dopdf.com/forum/topic/pdf-will-not-print-or-convert-all-of-excel-sheets-as-one#post-569 Wed, 04 Feb 2009 22:55:36 +0000 lesm 569@http://www.dopdf.com/forum/ <p>What gives, pdf will not print all of the selected sheets as one, it will convert the first sheet, then some in the middle and then the last one, I have a Excel doc with about 8 sheets (tabs).</p> <p>Les </p> http://www.dopdf.com/forum/topic/trouble-with-multiple-pdfs-with-one-workbook#post-318 Tue, 30 Sep 2008 09:21:17 +0000 Softland 318@http://www.dopdf.com/forum/ <p>Thanks for the addition Courval, will move this to Tutorials. </p> http://www.dopdf.com/forum/topic/trouble-with-multiple-pdfs-with-one-workbook#post-315 Mon, 29 Sep 2008 13:22:52 +0000 Courval 315@http://www.dopdf.com/forum/ <p>I wanted to add to the article as I followed it and it didn't really work.</p> <p>I wanted to print a workbook with 4 sheets all in one PDF. The first sheet was in Portrait format and the last 3 landscape. This is what I have done and it works:</p> <p>1. Set Print Area for each sheet<br /> 2. Set Page Set up options for each sheet individually (in particular in this case orientation [portrait / landscape] and Fit to 1 page by 1 page [in my case]<br /> 3. Follow the direction in the article linked to above and select Page Set up for all worksheets<br /> 4. Set the Paper Size and Print Quality for all sheets</p> <p>The problem I was having is that one sheet had a print quality of 300 dpi while the others had 600 dpi. This was generating 2 different PDFs that would overwrite each other. The above solved my problem and resulted in 1 PDF with different page orientations.</p> <p>HTH </p> http://www.dopdf.com/forum/topic/trouble-with-multiple-pdfs-with-one-workbook#post-281 Fri, 05 Sep 2008 06:44:01 +0000 Softland 281@http://www.dopdf.com/forum/ <p>Hi, actually this is an issue with the way Excel sends the pages for printing. Please see this article: <a href="http://www.novapdf.com/kb/printing-an-entire-excel-workbook-to-a-single-pdf-file-135.html">Printing an entire Excel workbook to a single PDF file</a><br /> It's applicable to doPDF too. </p> http://www.dopdf.com/forum/topic/trouble-with-multiple-pdfs-with-one-workbook#post-278 Thu, 04 Sep 2008 17:46:13 +0000 icsdata 278@http://www.dopdf.com/forum/ <p>Hello,<br /> I am having trouble when I print an Excel workbook. There are a total of 9 worksheets in the workbook with 90 "printable" pages. When I attempt to print using DoPDF, instead of printing a pdf with 90 pages, it attempts to split up the workbook into 6 different pdfs. This does not seem to correspond with the amount of worksheets or pages being printed. I think that this has something to do with the headers in the workbook, since when I create a new workbook in excel and attempt to recreate the problem, I cannot and one pdf is made with the merged multiple worksheets. I don't know if this is a problem with DoPDF since I have alternative pdf printers and all do the same thing. Is there any hope to fix this issue?</p> <p>Thanks in advance! </p>