Printing Excel workbook

[sallyb]

A regularly used workbook will no longer print all the pages I select as one
document. It breaks it up into two or three segments and I need it all
together. Currently my workaround is printing and scanning to save as a PDF.

 

[Gord Dibben]

How are you "selecting pages"?

Or do you mean "selected worksheets"?

Does each worksheet have a print range?


Gord Dibben MS Excel MVP

 

[sallyb]

I mean selected worksheets. Each worksheet does have a print range and it
will print. However, when I print to a PDF it separates it and will not
combine the worksheets together as one document.

 

[Gord Dibben]

What application are you using to to print to PDF?

Some Adode Acrobat versions have a hard time printing multiple sheets as one
document.

I use PrimoPDF.......FREE...... and have not had a problem with the
splitting.

http://www.primopdf.com/index.aspx


Gord

 

[sallyb]

I really don't believe it is a problem with the PDF program--PDFCreator which
is also free. There was no problem printing the many pages of the workbook
until recently when something changed. Even my budget detail with almost 50
pages was fine as one document but now does one page, then a couple smaller
groups. I don't know what to look for that may have changed in this workbook.
The same thing happened to a six page workbook that now prints 5 pages then 1
page. The PDF program is the same one and the workbook is also the same and
it used to work fine just a couple months ago.

 

[Gord Dibben]

Sounds like are convinced that Excel is the problem source.

Excel simply does what the printer driver tells it to do so I am not as
convinced as you are.

I have no resolution for you.

If you can pinpoint exactly when it quit working properly a couple of months
ago perhaps you can troubleshoot from that point.

Updates? New Application installed? ???


Gord

 

[sallyb]

Thanks for trying to help. I did download the PDF printer you recommended but
the outcome is exactly the same. Yes, I am convinced there is something
within the Excel document that is causing this. I will need to continue to
find a workaround since I cannot make it pull all active pages into one
document.