Try using PrimoPDF which is a free piece of software that will allows you to
'print' into one file. It also lets you 'lock' the documents so people can't
copy-paste plus various other things.

Web address is http://www.primopdf.com/





"global risk appetite " wrote:

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.