Multi sheet Excel file overwrites to single page PDF file

J

JulesSF

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a four sheet Excel worksheet.
When I try to Save As PDF in the print menu,
it will create one single page PDF document (displaying only the last sheet).

Upon hitting Save A PDF, the print process window will pop up four times, each time processing 1 page - and in the end all I have a one page document...

I have checked the DPI in the page setup, all four sheets are set to Normal.
 
C

CyberTaz

What you're not taking into consideration is that an Excel worksheet is not
a continuation of the previous sheet. The basic PDF generators apparently
aren't designed to distinguish between the end of page/sheet/file coding so
they barf when you send the entire workbook.

What should happen is that each sheet creates a separate PDF of however many
pages. You should wind up with 4 PDF files whose names are a combination of
the file name plus sheet name. Then use one of the PDF 'stitcher' utilities
to combine them into a single PDF file. Apple's Preview app version 5.x
enables this by simply dragging the individual PDFs into the Drawer. I
believe version 4.x did also but can't remember for sure. There are also a
number of free/shareware utilities for the purpose, and Acrobat can do the
same if you have it.
 
J

JulesSF

I wish Save As PDF would at least generate four seperate PDF files,
since I could use Acrobat 5 to stitch together,
but currently I have to save each single Excel sheet seperately to get four individual PDFs.

When I choose all four sheets to print to PDF, I end up with only the last page - indicating that with each page processing it overwrites whatever previous page.
 
C

CyberTaz

Well, this is weird...

If I use Excel 2008 to output a 3 sheet book using File> Print - Entire
Workbook - PDF it creates 3 separate PDFs, each one 2 pages. This is as I
would expect & the basis for my previous reply.

But if I do exactly the same with the same file on the same Mac using Excel
2004 I get the same result you're getting - 1 PDF for the last sheet only.

I honestly don't know what else to suggest :-(

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
J

JulesSF

Bob, thanks for running the trial!

Unfortunately, I do not have Excel 2008, but I tried the same file on the same computer with Office X: same problem!

I will download the 30 day trial of Office 2008 over the weekend and report back, if this will solve the problem ...
 
B

Bob Greenblatt

Bob, thanks for running the trial!

Unfortunately, I do not have Excel 2008, but I tried the same file on the same
computer with Office X: same problem!

I will download the 30 day trial of Office 2008 over the weekend and report
back, if this will solve the problem ...
Yes, this was a known problem that was fixed with Office 2008.
 
A

Alex Decadence

I am running Office 2004 on OS X 10.5, and got the same problem you did.

After extensive research I accidentally stumbled on the solution, all you have to do is hit the "PREVIEW" button which is to the right of "PDF" and it will open each sheet of the excel book separately on Mac's Preview, all you have to do then is drag the files to the order you want and save!

Hope this helps!

by the way I noticed your post is almost 5 months old... but oh well..



JulesS wrote:

Multi sheet Excel file overwrites to single page PDF file
29-Jan-10

Version: 200
Operating System: Mac OS X 10.5 (Leopard
Processor: Inte

I have a four sheet Excel worksheet. <br
When I try to Save As PDF in the print menu, <br
it will create one single page PDF document (displaying only the last sheet). <br><br>Upon hitting Save A PDF, the print process window will pop up four times, each time processing 1 page - and in the end all I have a one page document... <br><br>I have checked the DPI in the page setup, all four sheets are set to Normal.

Previous Posts In This Thread:

Multi sheet Excel file overwrites to single page PDF file
Version: 200
Operating System: Mac OS X 10.5 (Leopard
Processor: Inte

I have a four sheet Excel worksheet. <br
When I try to Save As PDF in the print menu, <br
it will create one single page PDF document (displaying only the last sheet). <br><br>Upon hitting Save A PDF, the print process window will pop up four times, each time processing 1 page - and in the end all I have a one page document... <br><br>I have checked the DPI in the page setup, all four sheets are set to Normal.

What you are not taking into consideration is that an Excel worksheet is nota
What you are not taking into consideration is that an Excel worksheet is no
a continuation of the previous sheet. The basic PDF generators apparentl
are not designed to distinguish between the end of page/sheet/file coding s
they barf when you send the entire workbook

What should happen is that each sheet creates a separate PDF of however man
pages. You should wind up with 4 PDF files whose names are a combination o
the file name plus sheet name. Then use one of the PDF 'stitcher' utilitie
to combine them into a single PDF file. Apple's Preview app version 5.
enables this by simply dragging the individual PDFs into the Drawer.
believe version 4.x did also but cannot remember for sure. There are also
number of free/shareware utilities for the purpose, and Acrobat can do th
same if you have it

-
HTH |:>
Bob Jone
[MVP] Office:Mac

I wish Save As PDF would at least generate four seperate PDF files, <br>since
I wish Save As PDF would at least generate four seperate PDF files, <br
since I could use Acrobat 5 to stitch together, <br
but currently I have to save each single Excel sheet seperately to get four individual PDFs. <br><br>When I choose all four sheets to print to PDF, I end up with only the last page - indicating that with each page processing it overwrites whatever previous page.

Well, this is weird...
Well, this is weird..

If I use Excel 2008 to output a 3 sheet book using File> Print - Entir
Workbook - PDF it creates 3 separate PDFs, each one 2 pages. This is as
would expect & the basis for my previous reply

But if I do exactly the same with the same file on the same Mac using Exce
2004 I get the same result you are getting - 1 PDF for the last sheet only

I honestly do not know what else to suggest :-

Regards |:>
Bob Jone
[MVP] Office:Ma


On 1/29/10 1:57 PM, in article (e-mail address removed)2ac0,

Bob, thanks for running the trial!
Bob, thanks for running the trial! <br><br>Unfortunately, I do not have Excel 2008, but I tried the same file on the same computer with Office X: same problem! <br><br>I will download the 30 day trial of Office 2008 over the weekend and report back, if this will solve the problem ...

this format, some or all of this message may not be legible.
this format, some or all of this message may not be legible.

--B_3347690722_51193701
Content-type: text/plain;
charset="US-ASCII"
Content-transfer-encoding: 7bit

On 1/29/10 10:11 PM, in article (e-mail address removed)2ac0,

Yes, this was a known problem that was fixed with Office 2008.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom


--B_3347690722_51193701
Content-type: text/html;
charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Multi sheet Excel file overwrites to single page PDF file</TITLE=
</HEAD>
<BODY>
<FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-size:10pt'>On 1/29/10 10:11 PM=
, in article <a href=3D"(e-mail address removed)2ac0">59bb1d61.3@webcros=
sing.JaKIaxP2ac0</a>, &quot;<a href=3D"(e-mail address removed)">JulesSF@offic=
eformac.com</a>&quot; &lt;<a href=3D"(e-mail address removed)">JulesSF@officef=
ormac.com</a>&gt; wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-size=
<BR>
Unfortunately, I do not have Excel 2008, but I tried the same file on the s=
ame computer with Office X: same problem! <BR>
<BR>
I will download the 30 day trial of Office 2008 over the weekend and report=
back, if this will solve the problem ...<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Lucida Grande"><SPAN STYLE=3D'font-siz=
e:10pt'>Yes, this was a known problem that was fixed with Office 2008.<BR>
</SPAN></FONT><FONT SIZE=3D"2"><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN S=
TYLE=3D'font-size:9pt'><BR>
-- <BR>
Bob Greenblatt [MVP], Macintosh<BR>
bobgreenblattATmsnDOTcom</SPAN></FONT></FONT><FONT FACE=3D"Lucida Grande"><SP=
AN STYLE=3D'font-size:10pt'><BR>
</SPAN></FONT>
</BODY>
</HTML>


--B_3347690722_51193701--


Submitted via EggHeadCafe - Software Developer Portal of Choice
Server Side Processing in ADO.NET/WCF Data Services
http://www.eggheadcafe.com/tutorial...f-4f6f92a76585/server-side-processing-in.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top