Ok, I'm about to shoot myself in the foot here so I hope someone can help me out. I am working on a parts catalog that is about 45 pages. I created it in Excel using a workbook. I am working on Mac OS X.

The thing is, I want to make the document, that is, the entire workbook, into one single PDF file. Right now, when I use "Print >> Entire Workbook >> Save as PDF" what happens is that instead of creating one single PDF with all the sheets becoming pages, it creates one single PDF PER SHEET after another, everytime compressing the previous sheet. So in the end, I get a PDF that is one single page - the last one... I've been struggling with this thing for days trying to see what could cause this in page setups etc... but I can't make any sense out of it. Please help!
Eric