Excel print to Adobe.pdf
 

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

Excel print to Adobe.pdf
 

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

What do you get ?

NickHK

"Nigel RS" wrote in message
...
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