Can only print ~3 pages from Excel to Adobe PDF

I've got a 30+ page Excel workbook, with 23 sheets that I want to print to a
pdf. I select all those 23 sheets, then do File / Print / <select Adobe
PDF> / OK.

It almost immediately comes up with the "Save PDF File As" dialog. If I
click save, it only saves three pages. If I keep clicking save (or cancel)
it staggers through it, wiping out the previous pdf and re-creating it with
only two or three pages at a time.

This happens whether or not I've clicked Printer / Properties and
de-selected "View Adobe PDF results" and/or "Prompt for Adobe PDF filename"
and/or "Add document information."

BTW, it does a perfect 23-page print-preview.

My OS is Windows XP, home edition, Version 2002, Service Pack 2
My Excel is 2000 (9.0.3821 SR-1)
My Adobe is Professional version 6.0.4 7/25/2005

I would be grately deepful if anybody could help.

Thanks
Tim Carr

Hi Timbo

Make sure that the "Print Quality" settings within Excel's "Page Setup"
options is the same for every sheet you want to print to a PDF file.

--

Regards

William

XL2003

willwest22@yahoo.com


"Timbo" <carrfamily@mindspring.com> wrote in message
news:MYJfg.7832$921.7074@newsread4.news.pas.earthlink.net...
> I've got a 30+ page Excel workbook, with 23 sheets that I want to print to
> a
> pdf. I select all those 23 sheets, then do File / Print / <select Adobe
> PDF> / OK.
>
> It almost immediately comes up with the "Save PDF File As" dialog. If I
> click save, it only saves three pages. If I keep clicking save (or
> cancel)
> it staggers through it, wiping out the previous pdf and re-creating it
> with
> only two or three pages at a time.
>
> This happens whether or not I've clicked Printer / Properties and
> de-selected "View Adobe PDF results" and/or "Prompt for Adobe PDF
> filename"
> and/or "Add document information."
>
> BTW, it does a perfect 23-page print-preview.
>
> My OS is Windows XP, home edition, Version 2002, Service Pack 2
> My Excel is 2000 (9.0.3821 SR-1)
> My Adobe is Professional version 6.0.4 7/25/2005
>
> I would be grately deepful if anybody could help.
>
> Thanks
> Tim Carr
>
>
>

You're absolutely right! When I grouped all the pages and made their print
quality be 600dpi, it worked perfectly. Thanks, thanks, thanks, kind sir!

"William" <willwest22@yahoo.com> wrote in message
news:uZ8ojMdhGHA.1508@TK2MSFTNGP04.phx.gbl...
> Hi Timbo
>
> Make sure that the "Print Quality" settings within Excel's "Page Setup"
> options is the same for every sheet you want to print to a PDF file.
>
> --
>
> Regards
>
> William
>
> XL2003
>
> willwest22@yahoo.com
>
>
> "Timbo" <carrfamily@mindspring.com> wrote in message
> news:MYJfg.7832$921.7074@newsread4.news.pas.earthlink.net...
>> I've got a 30+ page Excel workbook, with 23 sheets that I want to print
>> to a
>> pdf. I select all those 23 sheets, then do File / Print / <select Adobe
>> PDF> / OK.
>>
>> It almost immediately comes up with the "Save PDF File As" dialog. If I
>> click save, it only saves three pages. If I keep clicking save (or
>> cancel)
>> it staggers through it, wiping out the previous pdf and re-creating it
>> with
>> only two or three pages at a time.
>>
>> This happens whether or not I've clicked Printer / Properties and
>> de-selected "View Adobe PDF results" and/or "Prompt for Adobe PDF
>> filename"
>> and/or "Add document information."
>>
>> BTW, it does a perfect 23-page print-preview.
>>
>> My OS is Windows XP, home edition, Version 2002, Service Pack 2
>> My Excel is 2000 (9.0.3821 SR-1)
>> My Adobe is Professional version 6.0.4 7/25/2005
>>
>> I would be grately deepful if anybody could help.
>>
>> Thanks
>> Tim Carr
>>
>>
>>
>
>