Excel for Mac 2004 PDF Printing

I have a spreadsheet that when I print and select "All Worksheets", I am able to see the mulitple pages that are to be printed in the preview screen.  However, when I select to Save as PDF, the PDF file only contains the last printed page.  When printing, it shows that it is prinitng more than one page...  but as I mentioned, only the last printed page is in the file.

Excel for Mac 2011 prints all of the pages but just in separate files which I believe is a known bug.  My 2004 and 2011 have the latest updates.

Any solutions or work arounds?

Thanks.
rutherfordcpaAsked:
Who is Participating?
 
philip m o'brienCommented:
This is a known issue, and there is no simple way around it. The reason is that Excel is saving a PDF for each sheet but unfortunately, unlike in 2011, it uses the same filename for each. The end result is that the 2nd page overwrites the 1st, and the 3rd the 2nd etc so that you end up with the last page only.
The easiest way would be either a VBA routine to save them separately (or do this manually) and then create an automator script to stitch them together.
0
 
rutherfordcpaAuthor Commented:
Would you know of a VBA routine that is available?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.