Having problems printing more than 1 copy of a worksheet, I go to file;print
then check "entire workbook" and change the # of copies to what I would like
(say 20)
it only prints 1. It does this on all my saved worksheets so I know there is
a major setting that got changed but I cant find which one.

Some Printer drivers don't honor the request from excel, so you may have
to set the 20 in the printer properties setting rather than the Excel
Print dialog box.

Jeff wrote:

Having problems printing more than 1 copy of a worksheet, I go to file;print
then check "entire workbook" and change the # of copies to what I would like
(say 20)
it only prints 1. It does this on all my saved worksheets so I know there is
a major setting that got changed but I cant find which one.

What are you trying to print?

Subject line reads "multiple copies of a worksheet"

Then you state you selected "Entire Workbook"

You want 20 printed copies of one sheet or 20 copies of entire workbook?

20 copies of an entire workbook with multiple sheets could lead to mass
deforestation of the continent.

What is a "saved worksheet"?

You can only save workbooks, not worksheets.


Gord Dibben MS Excel MVP

On Mon, 21 Dec 2009 12:09:02 -0800, Jeff
wrote:

Having problems printing more than 1 copy of a worksheet, I go to file;print
then check "entire workbook" and change the # of copies to what I would like
(say 20)
it only prints 1. It does this on all my saved worksheets so I know there is
a major setting that got changed but I cant find which one.