[druber]

Trying to find a smarter way to send out reports at work. I have Excel docs with multiple worksheets that I'm trying to make into PDFs. When I print to PDF and tell it to print all sheets, it prints each individual page to PDF one at a time, resulting in a 1-page PDF with just the last worksheet.

I do have InDesign2, so I can drop the PDFs in there and output a multi-page PDF. That's going to get real labor-intensive, real fast. Also, can you use InDesign to create fancy PDFs with chapters and page titles and all that?

If I just get the full version of Adobe Acrobat, can I do all this? Stack of questions there, I know, but I thought I'd try.

[macmike42]

This definitely looks like a bug in Excel. Wierd. Tried printing 3 worksheets with both the standard "Save as PDF" and Adobe's PDF printer driver from Acrobat Pro, both only save the last sheet to the PDF. Too lazy to check if it does the same thing printing to my LaserJet...

Anyway, Acrobat Standard & Pro both allow you to join PDFs together into single PDFs.

[Mithras]

You want joinPDF

[druber]

I agree that it seems like a bug. I've noticed the same kind of thing on a Win2k machine at work, Excel97. The app has a real hard time trying to print collated sets.

Thanks Mithras, that looks like just what I need. Might save some cash there. Now to divert that to the office lunch fund. Thanks!