Print Page | Close Window

Excel: How to print all sheets in one PDF

Printed From: www.exp-systems.com
Category: PDF reDirect
Forum Name: Using PDF reDirect
Forum Discription: Questions and Comments on using PDF reDirect Freeware and Pro
URL: http://www.exp-systems.com/Forum_exp/forum_posts.asp?TID=31
Printed Date: 19 Aug 19 at 10:00PM


Topic: Excel: How to print all sheets in one PDF
Posted By: SDSimonsen
Subject: Excel: How to print all sheets in one PDF
Date Posted: 04 May 04 at 4:38AM

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




Replies:
Posted By: Michel_K17
Date Posted: 04 May 04 at 11:50PM

   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,



-------------
Michel Korwin-Szymanowski
EXP Systems LLC


Posted By: SDSimonsen
Date Posted: 06 May 04 at 3:34AM
Perfect! This solved my problem. Only my first page had the option set to high.


Posted By: Michel_K17
Date Posted: 06 May 04 at 9:18PM

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



Posted By: DJohn
Date Posted: 01 Mar 05 at 8:00PM

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.

 




Print Page | Close Window