EXP Systems Forum: Excel: How to print all sheets in one PDF

Author

Message

SDSimonsen
Newbie
Newbie

Joined: 04 May 04
Location: Faroe Islands
Posts: 2

Topic: Excel: How to print all sheets in one PDF
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

IP Logged

Michel_K17
Moderator Group

Forum Administrator

Joined: 25 Jan 03
Posts: 1673

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

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

IP Logged

SDSimonsen
Newbie
Newbie

Joined: 04 May 04
Location: Faroe Islands
Posts: 2

Posted: 06 May 04 at 3:34AM

Perfect! This solved my problem. Only my first page had the option set to high.

IP Logged

Michel_K17
Moderator Group

Forum Administrator

Joined: 25 Jan 03
Posts: 1673

Posted: 06 May 04 at 9:18PM

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

IP Logged

DJohn
Newbie
Newbie

Joined: 01 Mar 05
Posts: 1

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.

IP Logged

Using PDF reDirect
EXP Systems Forum : PDF reDirect : Using PDF reDirect

Author	Message
SDSimonsen Newbie Joined: 04 May 04 Location: Faroe Islands Posts: 2	Topic: Excel: How to print all sheets in one PDF 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
	IP Logged

Michel_K17 Moderator Group Forum Administrator Joined: 25 Jan 03 Posts: 1673	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 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
	IP Logged

SDSimonsen Newbie Joined: 04 May 04 Location: Faroe Islands Posts: 2	Posted: 06 May 04 at 3:34AM
	Perfect! This solved my problem. Only my first page had the option set to high.
	IP Logged

Michel_K17 Moderator Group Forum Administrator Joined: 25 Jan 03 Posts: 1673	Posted: 06 May 04 at 9:18PM
	Great! Thanks for posting back on your results. It'll help anybody else with the same problem.
	IP Logged

DJohn Newbie Joined: 01 Mar 05 Posts: 1	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.
	IP Logged