When printing multiple sheets in excel, PDF reDirect makes one file with the first page, and then asks for a new filename and puts the remaining pages into this second file. Is this a bug, or have I done somthing to the first sheet?

I am using Excel 2003 and PDF reDirect 1.2.2

   I'm not sure if one would call this a bug, but Microsoft has written a report on this problem (for Excel 97, but it also applies to Excel 2000), and how to fix it. I think Excel 2003 may have the same problem.

   The Microsoft article is located here: http://support.microsoft.com/default.aspx?scid=kb;en-us;166274&Product=xlw - http://support.microsoft.com/default.aspx?scid=kb;en-us;166274&Product=xlw

   Basically, you have to make sure that all the worksheets in the workbook are set to the same resolution (ie same dpi = "dots-per-inch"). To do so:

• Select all of your worksheets, then
• Select File -> Page Setup.
• On the Page tab there is a dropdown at the bottom of the screen that says "Print Quality": make sure it is set to 300 dpi.
• Save your file.
• Select "Print" and the PDF should now contain the selected worksheets all in one document.

   I have just tested this procedure on one of my documents using Excel 2000 and it fixed the problem. Please let me know if that also worked in Excel 2003.

   Best Regards,

Great! Thanks for posting back on your results. It'll help anybody else with the same problem.

Thanks!  This was posted awhile back, but I just found it.

I've been merging the multiple outputs back into one file.  This saves me time.