Trying to Print a Whole Workbook to a PDF File

[tvf8]

I have created a flip book with 12 woorksheets in Excel. I want to
print the whole thing to a PDF file in Mac OSX 10.3 which is usually
quite easy. For some reason when I go through the print dialog to
create a pdf the pdf is created but with only one worksheet. How do I
get the whole file to print to the same pdf with 12 pages?

 

[kimberly_dare]

Hi,

The default when you print from a Microsoft Excel workbook is to print
only the active worksheet. You will need to change it to print the
Entire Workbook. This is in the print dialog windown under the heading
of "Print What". Then you will be able to save it as a PDF. You
should see the print preview window change from one page to twelve
pages. I've just tested it and it functions as expected

Kim

 

[tvf8]

Kim,
Thanks for the help. I have been trying what you suggested and what
happens is that the print preview changes from 1 to 12 pages but when
the sytem actually converts the pages to the PDF format what shows on
the screen is a series of 12 individual progress bars, each showing a
one page conversion (not one progress bar showing a 12 page
conversion). Then in the folder that the PDF was saved to there is
only one file with a one page PDF, the rest one pagers are missing.
This is bizarre and the first issue I've had with printing to PDF with
OSX. Any other suggestions. Could it be some coruption in my system?
Tom

 

[Bernard Rey]

Thanks for the help. I have been trying what you suggested and what
happens is that the print preview changes from 1 to 12 pages but when
the sytem actually converts the pages to the PDF format what shows on
the screen is a series of 12 individual progress bars, each showing a
one page conversion (not one progress bar showing a 12 page
conversion). Then in the folder that the PDF was saved to there is
only one file with a one page PDF, the rest one pagers are missing.
This is bizarre and the first issue I've had with printing to PDF with
OSX. Any other suggestions. Could it be some coruption in my system?

It's kind of a bug. There have been messages about it now and then. It's an
issue that has been around since the release of Excel X. It's apparently
partially solved now: if you create a new workbook from scratch and print
three sheets, you'll have them correctly reproduced in the PDF document (I
just did).

But under "certain circumstances" you just can't. May be it's stuck inside
the data, I couldn't tell. I have some workbooks that just can't be saved as
PDFs, and others that can. The workbooks that can't, they still won't with
Excel 2004 as far as I can tell. The only "workaround" then is to merge the
PDFs into one, which you can do with Acrobat, of course, but you can also
find some other ways, like iMergePDFs (still in beta state):

http://www.automagic-software.com/downloads.php

 

[tvf8]

Bernard,
Thanks so much for the help.