• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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?

1 Solution
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.
rutherfordcpaAuthor Commented:
Would you know of a VBA routine that is available?
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.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now