Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Using PDF reDirect
 EXP Systems Forum : PDF reDirect : Using PDF reDirect
Topic: Excel: How to print all sheets in one PDF Post Reply Post New Topic
Author Message
SDSimonsen
Newbie
Newbie
Avatar

Joined: 04 May 04
Location: Faroe Islands
Posts: 2
Quote SDSimonsen Replybullet 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 IP Logged
Michel_K17
Moderator Group
Moderator Group
Avatar
Forum Administrator

Joined: 25 Jan 03
Posts: 1638
Quote Michel_K17 Replybullet 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 IP Logged
SDSimonsen
Newbie
Newbie
Avatar

Joined: 04 May 04
Location: Faroe Islands
Posts: 2
Quote SDSimonsen Replybullet Posted: 06 May 04 at 3:34AM
Perfect! This solved my problem. Only my first page had the option set to high.
IP IP Logged
Michel_K17
Moderator Group
Moderator Group
Avatar
Forum Administrator

Joined: 25 Jan 03
Posts: 1638
Quote Michel_K17 Replybullet 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 IP Logged
DJohn
Newbie
Newbie


Joined: 01 Mar 05
Posts: 1
Quote DJohn Replybullet 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 IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum