Excel print to Adobe.pdf

[Guest]

Hi All
I have a multi-sheet workbook that is printed to an Adobe.pdf writer. By
using Set Print ranges on each sheet, and then checking the Print entire
Workbook in what to print dialogue. All works fine and I end up with a
multipage Adobe.pdf.

Recently someone changed or added something to one or more worksheets, which
causes the above process to fault. I now get several pdfs with one or more
sheets. All sheets are printed to pdfs but not in one file!

Does anyone know what might cause the Adobe writer to create a new file
rather than a new page? It is definitely something in Excel not an Adobe
setting.

Cheers

 

[NickHK]

Nigel,
Create a new file with something to print on multiple sheets.
Print Entire Workbook.

What do you get ?

NickHK

 

[Guest]

Hi Nick
I tried this and it will create a single pdf. There is something in the
faulting workbook-sheets that is causing Adobe to split the file into
multiple pdfs. Weird!

I suspected that hidden sheets might be the problem but again adding these
do not cause the same fault. I have tried another machine with Excel and
Adobe and still the same for the faulty book.

Version of Excel 2003 SP2

Cheers

 

[NickHK]

Nigel,
Check the Page Setup details for each sheet for differences.
Also, is there any code in the _BeforePrints events ?

NickHK

 

[Francois via OfficeKB.com]

Hi Nick
I tried this and it will create a single pdf. There is something in the
faulting workbook-sheets that is causing Adobe to split the file into
multiple pdfs. Weird!

I suspected that hidden sheets might be the problem but again adding these
do not cause the same fault. I have tried another machine with Excel and
Adobe and still the same for the faulty book.

Version of Excel 2003 SP2

Cheers

I had this happen to me once, In my case it was the print page settings.....
make sure all the dpi settings are the same.

Nigel,
Create a new file with something to print on multiple sheets.

[quoted text clipped - 21 lines]

 

[Guest]

Hi
Yes that's it!! The dpi settings were different.

Thanks for the tip.

Cheers

Hi Nick
I tried this and it will create a single pdf. There is something in the
faulting workbook-sheets that is causing Adobe to split the file into
multiple pdfs. Weird!

I suspected that hidden sheets might be the problem but again adding these
do not cause the same fault. I have tried another machine with Excel and
Adobe and still the same for the faulty book.

Version of Excel 2003 SP2

Cheers

I had this happen to me once, In my case it was the print page settings.....
make sure all the dpi settings are the same.

Nigel,
Create a new file with something to print on multiple sheets.

[quoted text clipped - 21 lines]

Cheers

 

[Guest]

Hi Nick
It was the dpi settings for the pages that were different!

Many thanks for your help

Cheers

 

[Francois via OfficeKB.com]

Hi
Yes that's it!! The dpi settings were different.

Thanks for the tip.

Cheers

Hi Nick
I tried this and it will create a single pdf. There is something in the [quoted text clipped - 17 lines]

Cheers

Glad to help