Rita,

You need to change the default settings for the printer, not Excel. Go to
Printers & Faxes in your control Panel. Find the printer you want, right
click and select properties. Now uncheck "Collate" and click OK. These are
now saved as your default print settings. Note that none of your documents
will collate once you do this.

If this helps please click "Yes"
<<<<<<<<<<

"Rita" wrote:

I am trying to "uncheck" the collate box on the print options for Excel 2007
and then save the worksheet. I would like it to work like this always.
When I retrieve the worksheet again and print, it always collates.

Where do I set the default print settings for Excel 2007?

Example: We have a new Konica Bizhub 320 and if you choose 4 copies it
waits a second between copies if the collate box is checked. If the box is
unchecked, the printer immediately prints out 4 copies. Our old copier never
did this, so I need to change the default print settings in Excel and I think
it will function properly.

I have tried "print" "properties" and uncheck "collate", I save it and when
I bring it back up, it still tries to collate.

Thanks for any help you can give.