I have a workbook which contains six worksheets...nothing unusual there but
when I go to print the whole work book out it see the first three worksheets
as one document and the last three as another document...I have tried several
printers and creating as a PDF but end up with two
documents....ahhhhhhhhhhhhhhhhh

I can not find any reason, no unecessary links etc...

Can any one help ????

Mark

Mark

I can't explain why Excel sends the six sheets as two print jobs but.....

What occurs if you select first sheet tab and right-click then "select all
sheets" then go to Print dialog and "print selection"


Gord Dibben MS Excel MVP

On Fri, 24 Nov 2006 01:40:02 -0800, Mark Allen
wrote:

I have a workbook which contains six worksheets...nothing unusual there but
when I go to print the whole work book out it see the first three worksheets
as one document and the last three as another document...I have tried several
printers and creating as a PDF but end up with two
documents....ahhhhhhhhhhhhhhhhh

I can not find any reason, no unecessary links etc...

Can any one help ????

Mark

Same thing happens, I have 6 sheets as well. Select all, in the print
dialogue, it comes out as 3 seperate print jobs. I've tried both ways, either
"active sheets" or "entire workbook".

Any other ideas? All in pdf, and doesn't make any sense.

"Gord Dibben" wrote:

Mark

I can't explain why Excel sends the six sheets as two print jobs but.....

What occurs if you select first sheet tab and right-click then "select all
sheets" then go to Print dialog and "print selection"


Gord Dibben MS Excel MVP

On Fri, 24 Nov 2006 01:40:02 -0800, Mark Allen
wrote:

I have a workbook which contains six worksheets...nothing unusual there but
when I go to print the whole work book out it see the first three worksheets
as one document and the last three as another document...I have tried several
printers and creating as a PDF but end up with two
documents....ahhhhhhhhhhhhhhhhh

I can not find any reason, no unecessary links etc...

Can any one help ????

Mark

Gene

Which application are you using to print to PDF?

Some versions of Adobe Acrobat split each workbook into a separate PDF file for
each worksheet or several worksheets..

I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm


Gord

On Mon, 18 Dec 2006 12:35:01 -0800, Gene wrote:

Same thing happens, I have 6 sheets as well. Select all, in the print
dialogue, it comes out as 3 seperate print jobs. I've tried both ways, either
"active sheets" or "entire workbook".

Any other ideas? All in pdf, and doesn't make any sense.

"Gord Dibben" wrote:

Mark

I can't explain why Excel sends the six sheets as two print jobs but.....

What occurs if you select first sheet tab and right-click then "select all
sheets" then go to Print dialog and "print selection"


Gord Dibben MS Excel MVP

On Fri, 24 Nov 2006 01:40:02 -0800, Mark Allen
wrote:

I have a workbook which contains six worksheets...nothing unusual there but
when I go to print the whole work book out it see the first three worksheets
as one document and the last three as another document...I have tried several
printers and creating as a PDF but end up with two
documents....ahhhhhhhhhhhhhhhhh

I can not find any reason, no unecessary links etc...

Can any one help ????

Mark



Gord Dibben MS Excel MVP