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?