Save all Sheets in Workbook to one PDF file?

[GG]

I am trying to 'print/save as PDF' a workbook which contains 4 sheets
to one PDF file (multi-page PDF).
I am on Mac OS X 10.3.4 using Excel 2004.

It seems that no matter what I do, only one page gets saved to PDF. If
I select all sheets and then go to Print with 'Active Sheets'
selected, once I save as PDF one the last sheet gets saved to the PDF
file.

If I try and select 'Entire Workbook' the same happens.

Is this a limit with Mac OS X's PDF feature or a known bug?
Has this ever been possible with previous version of Excel on Mac?

Thanks for any help
Jay

 

[Jim Gordon MVP]

Hi GG,

I thought this had been fixed in XL 2004, but I guess it wasn't.

Please send to Microsoft a feature request describing the desired behavior.
Use the feedback feature on Excel's help menu to get your suggested into
their tracking system.

Thanks.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[GG]

Thanks Jim,
This is really disappointing. I did some more digging after posting my
initial questions and I read that this has always been a problem,
Microsoft even have a bug page which details it.

Why non earth could they not fix this for the new version, they have
had three years!
Not good, will be sending in a report.
Jay

 

[Bill]

I ran into the same problem and used AppleScript to print each
file/sheet to a separate PDF, then scripted PDFPen to merge the
individual PDFs into one. PDFPen is not the best PDF viewer, but it
has a great AppleScript dictionary and includes sample scripts to base
your own scripts on. A temporary fix, but a fix none-the-less.

 

[Dr Rocket]

Here are two work-arounds for this chronic bug.

1. Copy and paste each Excel page onto a single worksheet, for example
each page below the previous. If you have a problem, you may need to
Paste Special as Values and Formats. Select all the pages on the
single worksheet, and designate this as the Print Area (File>Print
Area>Set Print Area). You can insert page numbers and total pages in
headers and footers for the whole multi-page document from View>Header
and Footer … .

You can check and adjust the pagination, especially if the pages are
different sizes, under View>Page Break Preview. You can also control
the sequence of page printing.

Now either print to Adobe PDF (File>Print…>Printer>pull down menu) or
save as a PDF file (File>Print…>Save as PDF…). Excel should now give
you what you expected.

2. If you use the total number of pages (&[Pages]), replace it
manually (View>Header and Footer …). Save or print the first page as a
PDF document, as in #1. For each following page, group it with all the
preceeding pages, and save or print the Group as PDF, and the bug will
give you just the last page. Or, you can mannually replace both the
page number (&[Page]) and the total in the Header and Footer for each
page, and then print or save each page as a PDF document. Now you can
mannually assemble the multi-page document with Adobe Acobat, using
Document>Pages>Insert.

Jeff Glassman