Printing Workbook to Pdf or xps vs physical printer 1

[DrSimon]

Firstly - apologies if the answer to this has been posted before, but I've searched and can't find it!

I am using Excel 2010. I have a multisheet workbook that prints fine to a physical printer when using 'Print Entire Workbook'. However if I change the printer to pdf (I have Abode Acrobat X Standard) or XPS Document Writer it seems to close the output file after completing each sheet and ask for a new file name. I would like the get the pdf output in one file.
Does anyone know if that's how it's supposed to work, of if there is any setting I could use to resolve this? Happy to go down the VBA route if there's a solution available.

Thanks

 

[darryncooke]

it works fine for me here. Make sure the settings are not changed. Check if you have the most up to date Adobe drivers.

Darryn Cooke

http://www.darryncooke.com

| Marketing and Creative Services

 

[DrSimon]

Thanks for the quick reply. As far as I can tell, the Adobe drivers are up-to-date. What's odd is that the same thing happens for xps output too. I can't find any other settings to change. All I did was first print to the physical network printer and then change the printer to Adobe and xps without any other changes.
Simon

 

[JVFriederick]

DrSimon

Sorry if this is too late to respond to your post ..............

Check the print quality setting on each sheet. i.e. Page Layout + Page Setup

I am thinking they are not all the same.

If one sheet is 600dpi and another is 1200dpi the PDF driver will split into separate files.

 

[DrSimon]

Brilliant JVFrederick!
Definitely not too late. I would never have thought or even looked for that.

Simon

 

[JVFriederick]

Learned by previous personal frustration.

Just passing on the relief!