Printing Multiple Worksheets as a single print job

M

MGatESSInc

My problem is as such:

I use Excel 2002 to maintain a list of refurbished endoscopic equipmen
offered for sale by our company. I have it broken down int
"sub-categories" so the workbook has 6 worksheets (or 6 tabs).

The way the document reads, it's supposed to come out as one continuou
document (print entire workbook). However, when it prints, it print
the first two tabs as one print document, then the third as a separat
document, then the fourth, fifth & sixth tabs as another - therefore
it's actually 3 separate documents being sent to the printer.

This isn't too much of a problem when I send it to a regular pape
printer. The problem comes when I send it to Adobe Acrobat v5 throug
Acrobat Distiller - it makes 3 separate .pdf documents that I then hav
to combine to make one document.

I've printed multi-tabbed/worksheet Excel workbooks before withou
running into this problem. I only have this problem with thi
particular workbook. Are there any settings I can change that wil
force it to print all these worksheets as one print job so that makin
PDFs will go smoother and quicker? :confused:

~Mark G.
[email protected]
 
Top