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




"Timbo" wrote in message
ink.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" wrote in message
...
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




"Timbo" wrote in message
ink.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