PDF'ing in MS Excel 2003: Avoiding having each Excel tab saved as separate PDF file

[global risk appetite]

I'm noticing this while trying to PDF in MS Excel (2003). When I try
to send the pages I'm interested in PDF'ing to the printer to create
an Adobe document, the tabs are all saved as separate files. I have
up to 200 pages that I need to PDF, and many of these documents are in
fairly complex Excel models in different tabs.

Is there any way to bypass this - in other words, have all the tabs
that I've selected to print, save as a single Adobe file, so that I
don't have to combine them later into one, consolidated document?

By the way, I noticed that when I do this at home using MS's
PdfFactory, the whole thing saves as a single file. But my cheap
employer isn't interested in getting PdfFactory. Anything that I can
do. Btw, the Adobe we're using at work is not the most recent Adobe
read/write either. I believe it's either 6.0 or 7.0 Adobe
Professional which enables reading, writing, combining, encrypting,
etc. Thanks.

 

[bhjohnson100]

I'm noticing this while trying to PDF in MS Excel (2003). When I try
to send the pages I'm interested in PDF'ing to the printer to create
an Adobe document, the tabs are all saved as separate files. I have
up to 200 pages that I need to PDF, and many of these documents are in
fairly complex Excel models in different tabs.

Is there any way to bypass this - in other words, have all the tabs
that I've selected to print, save as a single Adobe file, so that I
don't have to combine them later into one, consolidated document?

By the way, I noticed that when I do this at home using MS's
PdfFactory, the whole thing saves as a single file. But my cheap
employer isn't interested in getting PdfFactory. Anything that I can
do. Btw, the Adobe we're using at work is not the most recent Adobe
read/write either. I believe it's either 6.0 or 7.0 Adobe
Professional which enables reading, writing, combining, encrypting,
etc. Thanks.

I'm using Excel 2003, too, with Adobe Std. 6. On the print, I select
"Entire workbook" and print to the PDF printer. It gives me everything
in one file. Perhaps the Print Selection works differently if
selecting only certain tabs?