Excel for Mac 2004 PDF Printing

Posted on 2011-05-03
Last Modified: 2012-05-11
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?

Question by:rutherfordcpa
    LVL 7

    Accepted Solution

    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.

    Author Comment

    Would you know of a VBA routine that is available?
    LVL 50

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
    In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
    Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now