>----- Original Message ----- >From: "Robert Poland" <rpoland at usa.net> >To: "X-Applications" <X-Apps at lists.themacintoshguy.com> >Sent: Thursday, October 09, 2003 12:54 PM >Subject: [X-Apps] Summary: Print to PDF > > >> Found this on the Mactopia web site. >> http://support.microsoft.com/default.aspx?scid=kb;en-us;325995 >> >> MacXLX: Workbook That Is Printed to PDF File Does Not Include All >Worksheets >> This article applies to. >> This article was previously published under Q325995 >> >> SYMPTOMS >> After you print an Excel workbook with multiple worksheets to a PDF >> file and then view the PDF version, the PDF file does not include all >> the worksheets. >> >> WORKAROUND >> To work around this issue, print each sheet to a PDF file separately. >> To do this, follow these steps: >> >> What can I say, !@#$^&() >> >> Thanks to those who tried to help. >> -- >> Bob Poland - Englewood, CO >> http://www.ibrb.org/ > >There is another way around this but it requires you to have a full version >of Acrobat. If you do, then in Excel choose print... and when you get the >print dialog choose "print to file". this will generate what is called an >EPS file. Open Acrobat and use the Distiller application to build the PDF. >Also if you do a Google search for PDF generators you may be able to find >some shareware that will distill the file. > >Joe Ell Been there, Done that. But I tried again, just to be sure. Looks like that writes every sheet as the same file and overwrites the preceding one leaving only the last sheet. Will try Google later. Thanks, -- Bob Poland - Englewood, CO http://www.ibrb.org/