Printing Excel workbook

  • Thread starter Thread starter sallyb
  • Start date Start date
S

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.
 
How are you "selecting pages"?

Or do you mean "selected worksheets"?

Does each worksheet have a print range?


Gord Dibben MS Excel MVP
 
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.
 
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
 
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.
 
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
 
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.
 
Back
Top