Saving multiple sheets into 1 pdf form

M

MCubed

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When I try to save 2 excel sheets (in 1 workbook) into 1 pdf file it saves them individually. Of course my fellow PC user can save the 2 sheets into 1 pdf file (multiple pages) but I cannot seem to figure it out for a MAC. Is it just not an option?
Thank you!!
 
C

CyberTaz

Unfortunately Apple & MS are both saddled with the same Adobe Acrobat
limitations on the Mac, but there is a relatively simple workaround...

Generate the multiple PDFs then open"page 1" in Apples Preview app and
display the Drawer (now called a Sidebar). Bring a Finder window up,
navigate to where the other "pages" are stored & drag them into the Drawer
(you can select & drag more than one at a time). Rearrange if necessary &
SAVE as a single PDF. If you happen to have Acrobat you can combine the PDFs
there as well as with a number of PDF "stitcher" utilities available on the
web ‹ most of which are freeware/shareware.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
S

solomon.quansah

have the same problem.

I contacted Adobe and they said that the problem is with the WAY EXCEL SENDS THE WORKSHEETS TO ADOBE ACROBAT. This means that technically the problem is with the way Excel has been designed. i confirmed this for myself when i created another workbook in IWorks' Numbers and it printed the whole worksheet as one pdf file without any problem.

The workaround you've prescribed is TOO LONG A PROCESS WHEN I CAN JUST DO ONE CLICK IN OTHER PRODUCTS AND GET THE RESULT THAT I WANT.

I (AND I'M SURE MANY EXCEL FOR MAC USERS) WILL REALLY APPRECIATE THIS PROBLEM BEING FIXED INSTEAD OF BEING TOLD TO DO A TEN CLICK AND PROCESSES WORKAROUND.

THANK YOU,
 
C

CyberTaz

Perhaps you might like to ask Adobe why they continue to sing the same old
song when Mac Excel sends content in exactly the same manner that PC Excel
does, yet the phenomenon doesn't occur on a PC. While you're at it you might
also ask them why their PDF *printer* can't reproduce in a file what
literally every other printer driver on the planet has no problem with :)

It might also be interesting to know what Adobe has to say about why the
Acrobat 9 PDF driver *can* avoid multiple PDFs from a single file but the
utility they're offering Apple & MS for use on Macs just doesn't seem to
have the same capabilities... You do realize that virtually *all* PDF
generators are licensed from Adobe, right?

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

John McGhie

Who did you think you are shouting at?

Did you imagine Microsoft or Adobe were reading here? Sorry to burst your
bubble, but there's no-one here but us fellow users.

Some of us have ideas about things we would like the Microsoft Corporation
to do, also. But we don't work there, and we have no say in the matter.

We come in here trying to offer fellow users a way to use the software the
way Microsoft made it. Nobody pays us for this: we are just trying to help
people because it makes us feel good.

At least, it makes us feel good except when ungrateful types shout at us...



have the same problem.

I contacted Adobe and they said that the problem is with the WAY EXCEL SENDS
THE WORKSHEETS TO ADOBE ACROBAT. This means that technically the problem is
with the way Excel has been designed. i confirmed this for myself when i
created another workbook in IWorks' Numbers and it printed the whole worksheet
as one pdf file without any problem.

The workaround you've prescribed is TOO LONG A PROCESS WHEN I CAN JUST DO ONE
CLICK IN OTHER PRODUCTS AND GET THE RESULT THAT I WANT.

I (AND I'M SURE MANY EXCEL FOR MAC USERS) WILL REALLY APPRECIATE THIS PROBLEM
BEING FIXED INSTEAD OF BEING TOLD TO DO A TEN CLICK AND PROCESSES WORKAROUND.

THANK YOU,

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!

--

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 
J

jrsemerson

Thank you for this post. I am sturggling with the SAVE AS A SINGLE PDF part. While i can get all the pdfs in the "Sidebar" when i save it only saves the pdf I am viewing even when i choose Save As...Help please!
 
C

CyberTaz

Yeah, I guess I didn't give you enough detail :) Although I'm using Preview
5.0 in Snow Leopard IIRC this will also do the job in 4.x...

Select an item in the Sidebar, then Command+A to Select All
Use File> Print Selected Pages
Hit the PDF button in the Print dialog & select Save As PDF (or whatever) &
go from there.
 
J

jrsemerson

Worked like a charm - many thanks! The trick for me was "printing" as pdf in preview not "saving".
 
C

CyberTaz

No Problem -- sorry not to have been more clear to begin with :-}

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

wdkstratus

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When I try to save 2 excel sheets (in 1 workbook) into 1 pdf file it saves them individually. Of course my fellow PC user can save the 2 sheets into1 pdf file (multiple pages) but I cannot seem to figure it out for a MAC. Is it just not an option?
Thank you!!

2.5 years later and the problem is still there for Excel 2011 and the PDF printer. I am not so sure I ascribe to the Adobe conspiracy theory, but what do I know - I'm just a user. Maybe I should try the Mac workbook... at least for PDF printing, which I have to do all the time. OR... any updates on more efficient workarounds??? My workbooks have many pages, and dragging them all into preview frequently rearranges the pages.
 
R

Richard H

2.5 years later and the problem is still there for Excel 2011 and the PDF
printer. I am not so sure I ascribe to the Adobe conspiracy theory, but what
do I know - I'm just a user. Maybe I should try the Mac workbook... at least
for PDF printing, which I have to do all the time. OR... any updates on more
efficient workarounds??? My workbooks have many pages, and dragging them all
into preview frequently rearranges the pages.

I use Combine PDFs:

<http://download.cnet.com/Combine-PDFs/3000-2193_4-41822.html>
 
S

spsnomad

If anyone from Microsoft does read this, please be aware that those of us who support printers get calls about this all the time, and there isn't a thing we can do about it, because Excel jobs are separated by the sheet. Under Windows, page setup applies only to the individual spreadsheet, rather than to the entire workbook. On the Mac side, it sends jobs separately, which makes it impossible to do stapled/duplexed sets without some complex workarounds.

I'll never know why Microsoft hasn't fixed this; it's been an issue for us for at least 10 years, and it has resulted in some furious customers.
 
M

murray.elliot

Perhaps you might like to ask Adobe why they continue to sing the same old
song

You might want to ask Microsoft why they sing the same old song too... There are no innocents in the software industry, only the guilty.

Regards |:>)

Murray Elliot
IT professional for 30 years
 
M

mgsharifh

Yeah, I guess I didn't give you enough detail :) Although I'm using Preview
5.0 in Snow Leopard IIRC this will also do the job in 4.x...

Select an item in the Sidebar, then Command+A to Select All
Use File> Print Selected Pages
Hit the PDF button in the Print dialog & select Save As PDF (or whatever) &
go from there.


Thanks Cyber Taz, magic.

However what I did was:

- Command+A to Select All
- Tick Scaling Fit to " 1 "
- Bottom left corner, save as PDF

Im assuming I could also PRINT in one page and look tech smart, rather than the norm
of chopping up my 1 page work in half and look suspicious :-D !

Thank you!
 
R

rinnie.ton

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

When I try to save 2 excel sheets (in 1 workbook) into 1 pdf file it saves them individually. Of course my fellow PC user can save the 2 sheets into1 pdf file (multiple pages) but I cannot seem to figure it out for a MAC. Is it just not an option?
Thank you!!

Hi,
I'm no expert but this seems to work for me. I select the tabs I want, then click on print preview. The file will show up in pdf then I save a copy of it. Keep in mind, acrobat is my default application for print preview, instead of "Preview" app. Hope it works for you :)
 

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