Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / September 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
global risk appetite < - 03 Sep 2007 07:27 GMT
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@gmail.com - 03 Sep 2007 15:10 GMT
On Sep 2, 11:27 pm, global risk appetite
<<fundam...@equityinvestor.com>> 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
[quoted text clipped - 13 lines]
> 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?
AnandaSim - 07 Sep 2007 07:37 GMT
On Sep 3, 4:27 pm, global risk appetite
<<fundam...@equityinvestor.com>> wrote:

> 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

I noticed there were differences in the way the printer drivers
handled this. When selecting multiple tabs and using FinePrint PDF
Factory Pro (an old version), it accumulated as one job. When I tried
PrimoPDF and something else, it split into different jobs. I didn't
follow up on this difference as my client didn't come back for more.

Ananda

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.