Can only print ~3 pages from Excel to Adobe PDF

[Timbo]

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

 

[William]

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

(e-mail address removed)

 

[Timbo]

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!