I am the unofficial IT guy at my work and I have a strange problem that I can
not make sense of.

The accounting department has a WIP that they print that is made up of
multiple worksheets in a single workbook in Excel 2007. When they print
multiple copies of the entire workbook and collate. It prints the first page
(?)copies and the pages 2-6 (?)copies collated and the the rest of the work
book (?)copies collated.

I thought it was a driver issue so I sent it to another printer and the same
exact thing happened.

What is causing this to happen?

Jame,

I recently had this problem too and it turned out to be that under the page setup for each workbook the Print Quality DPI were set differently. If you change them to the same setting they will print correctly.


-Tyler



Jame wrote:

Excel Collate Problem
10-Dec-08

I am the unofficial IT guy at my work and I have a strange problem that I can
not make sense of.

The accounting department has a WIP that they print that is made up of
multiple worksheets in a single workbook in Excel 2007. When they print
multiple copies of the entire workbook and collate. It prints the first page
(?)copies and the pages 2-6 (?)copies collated and the the rest of the work
book (?)copies collated.

I thought it was a driver issue so I sent it to another printer and the same
exact thing happened.

What is causing this to happen?

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx