I have created a new workbook with 2 worksheets in Excel 2002. There is
some text on both worksheets.

Now I select both tabs, Sheet 1 and Sheet 2. I want to setup all worksheets
to print 2 copies.

With both tabs selected I go to Page Setup | Sheet | Options | Advanced |
and change Copy Count to 2, non collated. Now when I go to File | Print I
would expect to see 2 copies for both pages. For some reason it is not
working. I see 2 copies for the last worksheet that I selected but only 1
copy for the other worksheet.

Is this not the correct procedure or is there a problem with my Excel? All
help is appreciated. TIA!