Printing Active Sheets to a PDF File

Peter Boekelheide via Adm · External Since: Aug 28, 2004 Posts: 1

(Type your message here)
I've got a user that wants to print only certain sheets to a single PDF file using the Adobe PDFWriter. However, when he selects the sheets he wants and goes to print them to the writer with the "Active Sheets" radio button checked, it does not work. Instead of printing one PDF file with all sheets inside it in makes several PDF files, each one sheet. Is the only way around this to then merge the three together afterwards?

--------------------------------
From: Peter Boekelheide

-----------------------
Posted by a user from AdminLife (http://www.adminlife.com/)

<Id>pLFDP2CWokWFc1Zae2cCmw==</Id>

Paul Cundle · External Since: Jan 14, 2004 Posts: 90

Try here:
<a style='text-decoration: underline;' href="http://tinyurl.com/4394g" target="_blank">http://tinyurl.com/4394g</a>
and looking at the links contained therein. I think you're going to be
disappointed.

Paul C,
--

Peter Boekelheide via AdminLife wrote:
> (Type your message here)
> I've got a user that wants to print only certain sheets to a single
> PDF file using the Adobe PDFWriter. However, when he selects the
> sheets he wants and goes to print them to the writer with the "Active
> Sheets" radio button checked, it does not work. Instead of printing
> one PDF file with all sheets inside it in makes several PDF files,
> each one sheet. Is the only way around this to then merge the three
> together afterwards?

BowMag · External Since: Sep 29, 2004 Posts: 7

Dear Peter

I had the same problem. I now use a pdf program called WIN2PDF and simply
select the worksheets I want and print to the win2pdf 'printer'. Works
every time.

access them at <a style='text-decoration: underline;' href="http://www.win2pdf.com/" target="_blank">http://www.win2pdf.com/</a>

BowMag

"Paul Cundle" <news.TakeThisOut@cundle.co.uk> wrote in message
news:eoV5m6SjEHA.3148@TK2MSFTNGP10.phx.gbl...
> Try here:
<font color=purple> > <a style='text-decoration: underline;' href="http://tinyurl.com/4394g</font" target="_blank">http://tinyurl.com/4394g</font</a>>
> and looking at the links contained therein. I think you're going to be
> disappointed.
>
> Paul C,
> --
>
> Peter Boekelheide via AdminLife wrote:
  >> (Type your message here)
  >> I've got a user that wants to print only certain sheets to a single
  >> PDF file using the Adobe PDFWriter. However, when he selects the
  >> sheets he wants and goes to print them to the writer with the "Active
  >> Sheets" radio button checked, it does not work. Instead of printing
  >> one PDF file with all sheets inside it in makes several PDF files,
  >> each one sheet. Is the only way around this to then merge the three
  >> together afterwards?
>
>

David A. Smith · External Since: Nov 08, 2004 Posts: 2

"Peter Boekelheide via AdminLife" wrote:

> (Type your message here)
> I've got a user that wants to print only certain sheets to a single PDF file using
> the Adobe PDFWriter. However, when he selects the sheets he wants and
> goes to print them to the writer with the "Active Sheets" radio button checked,
> it does not work. Instead of printing one PDF file with all sheets inside it in
> makes several PDF files, each one sheet. Is the only way around this to then
> merge the three together afterwards?

I found a fix to this problem, that works in Office 2000 anyway...

Each worksheet is created from a single worksheet.
Right click on the target worksheet, "Move or Copy", check "Make a Copy".

DON'T Insert->Worksheet.
DON'T populate more than a single worksheet that is to be printed from the
auto-generated ones.

Then format away. The result for me was a five page, single pdf, three
pages portrait, and two pages landscape (with graphics). Before applying
this trick, I had three individual pages (each as their own pdf) and a pair
of pages that had been copied one from the other (which was the clue)

Yes, it is a pain in the tush to copy the contents and the column widths
from existing spreadsheets, but it does pay off...

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

David

Less pain in the tush.............

I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.

<a style='text-decoration: underline;' href="http://www.rcis.co.za/dale/info/pdfguide.htm" target="_blank">http://www.rcis.co.za/dale/info/pdfguide.htm</a>

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

Gord Dibben Excel MVP

On Mon, 8 Nov 2004 14:14:01 -0800, "David A. Smith"
<DavidASmith.RemoveThis@discussions.microsoft.com> wrote:

>"Peter Boekelheide via AdminLife" wrote:
>
  >> (Type your message here)
  >> I've got a user that wants to print only certain sheets to a single PDF file using
  >> the Adobe PDFWriter. However, when he selects the sheets he wants and
  >> goes to print them to the writer with the "Active Sheets" radio button checked,
  >> it does not work. Instead of printing one PDF file with all sheets inside it in
  >> makes several PDF files, each one sheet. Is the only way around this to then
  >> merge the three together afterwards?
>
>I found a fix to this problem, that works in Office 2000 anyway...
>
>Each worksheet is created from a single worksheet.
>Right click on the target worksheet, "Move or Copy", check "Make a Copy".
>
>DON'T Insert->Worksheet.
>DON'T populate more than a single worksheet that is to be printed from the
>auto-generated ones.
>
>Then format away. The result for me was a five page, single pdf, three
>pages portrait, and two pages landscape (with graphics). Before applying
>this trick, I had three individual pages (each as their own pdf) and a pair
>of pages that had been copied one from the other (which was the clue)
>
>Yes, it is a pain in the tush to copy the contents and the column widths
>from existing spreadsheets, but it does pay off...

Alan · External Since: Sep 12, 2003 Posts: 120

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:b790p0llbtht8ls6klogurjfqnvkuc4ltv@4ax.com...
>
> David
>
> Less pain in the tush.............
>
> I have had success with the free file downloads and instructions for
> use here at Dale Nurden's site.
>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.rcis.co.za/dale/info/pdfguide.htm</font" target="_blank">http://www.rcis.co.za/dale/info/pdfguide.htm</font</a>>
>
> Saves first to single *.ps file which is then converted to *.pdf
>
> Returns one PDF file from multiple sheets.
>
> Gord Dibben Excel MVP
>

This is possibly even less of tush issue:

D:\Programs\GhostScript 8.14\FreeDist v3.0\FreeDist - Info Page.mht

This will append multiple PDFs into one and doesn't even require
installing. It works great for me under Win2k Pro so it should be
fine for WinXP too I guess.

There is also some sample excel VBA code at the bottom of that page,
but I have never bothered to use it - I just create the PDFs normally,
then append each of them to the first.

HTH,

Alan.

T-Rex · External Since: Nov 10, 2004 Posts: 5

Gord
I just installed Adobe Acrobat Prof. 6.0, and it also appears to have
problems with printing multiple
excel active worksheets to a .pdf file. Amazing... this is the latest and
greatest Adobe product and it screws up
on apparently one of the most common printing tasks an excel user has.
However, I found your note to David at this ng
and I used your recommended method of printing to a .ps file. While I have
ghostscript and GSview, the
recently installed Adobe grabbed the file extension association for .ps. I
doubled clicked on the .ps file and the newly
installed Distiller made the conversion just fine. thanks for the excellent
pointer.

T-REX

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:b790p0llbtht8ls6klogurjfqnvkuc4ltv@4ax.com...
> David
>
> Less pain in the tush.............
>
> I have had success with the free file downloads and instructions for use
here
> at Dale Nurden's site.
>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.rcis.co.za/dale/info/pdfguide.htm</font" target="_blank">http://www.rcis.co.za/dale/info/pdfguide.htm</font</a>>
>
> Saves first to single *.ps file which is then converted to *.pdf
>
> Returns one PDF file from multiple sheets.
>
> Gord Dibben Excel MVP
>
> On Mon, 8 Nov 2004 14:14:01 -0800, "David A. Smith"
> <DavidASmith.TakeThisOut@discussions.microsoft.com> wrote:
>
  > >"Peter Boekelheide via AdminLife" wrote:
  > >
   > >> (Type your message here)
   > >> I've got a user that wants to print only certain sheets to a single PDF
file using
   > >> the Adobe PDFWriter. However, when he selects the sheets he wants and
   > >> goes to print them to the writer with the "Active Sheets" radio button
checked,
   > >> it does not work. Instead of printing one PDF file with all sheets
inside it in
   > >> makes several PDF files, each one sheet. Is the only way around this to
then
   > >> merge the three together afterwards?
  > >
  > >I found a fix to this problem, that works in Office 2000 anyway...
  > >
  > >Each worksheet is created from a single worksheet.
  > >Right click on the target worksheet, "Move or Copy", check "Make a Copy".
  > >
  > >DON'T Insert->Worksheet.
  > >DON'T populate more than a single worksheet that is to be printed from
the
  > >auto-generated ones.
  > >
  > >Then format away. The result for me was a five page, single pdf, three
  > >pages portrait, and two pages landscape (with graphics). Before applying
  > >this trick, I had three individual pages (each as their own pdf) and a
pair
  > >of pages that had been copied one from the other (which was the clue)
  > >
  > >Yes, it is a pain in the tush to copy the contents and the column widths
  > >from existing spreadsheets, but it does pay off...
>

rob621 · External Since: Apr 19, 2007 Posts: 1

This is what worked for me...
FILE>Page Setup
Options...
This opens Adobe PDF Document Properties
"Edit"...Default Settings
This opens (on my computer) "Standard Adobe PDF Settings"
On the drop down list change "compatability" to Acrobat 7.0 (PDF 1.6)
or whatever version you are running.

--
rob621

rob621 · External Since: Apr 20, 2007 Posts: 1

rob621;7523009 Wrote:
> This is what worked for me...
> Select Adobe PDF as your printer
> FILE>Page Setup
> Options...
> This opens Adobe PDF Document Properties
> "Edit"...Default Settings
> This opens (on my computer) "Standard Adobe PDF Settings"
> On the drop down list change "compatability" to Acrobat 7.0 (PDF 1.6)
> or whatever version you are running.

You must have PDF selected as the printer otherwise different dialogue
boxes appear

--
rob621

droberts1234 · Joined: Aug 13, 2009 Posts: 1

I was having this trouble with a large Workbook that contained many sheets. The PDF print dialog prompted me several times for a new output file name. I had about 30 sheets but was prompted only six times for a new name. I discoved that the DPI setting (file - page setup) was not the same for all sheets. Once I set the DPI to be the same for all sheets, then the entire Workbook printed to one file with no problem.