Uncheck collate by default to avoid printer error David H. 12/2/2008 8:31:01 PM When I print multiple copies of an Excel document (Excel 2003 or 2007 on Windows XP) it prints one copy OK, then generates an error on the printout. (The problem is very similar to the one discussed in http://support.microsoft.com/kb/948349, but that solution is for a different OS.) To avoid this error I need to uncheck the "collate" option in the Print dialog box. Fine. Is there any way I can get Excel to always leave that option unchecked? As it is, the option is always checked, even if I have just printed the document with it unchecked. Obviously I could create a simple macro to print 6 copies, uncollated. But I sometimes need 2 copies, sometimes 20, so a macro isn't an easy fix. Any suggestions?

Re: Uncheck collate by default to avoid printer error "Shane Devenshire" <shanedevenshire[ at ]sbcglobal.net> 12/29/2008 7:07:18 AM Hi, I can't test this right now but I think if you choose File, Print, and click the Properties button you may find a Collate property which will stay off. Cheers, Shane Devenshire "David H." <davidh[ at ]newspostalias.com> wrote in message news:01F6F6CB-A828-410F-B2E3-A2163F9063D6[ at ]microsoft.com... [Quoted Text] > When I print multiple copies of an Excel document (Excel 2003 or 2007 on > Windows XP) it prints one copy OK, then generates an error on the > printout. > (The problem is very similar to the one discussed in > http://support.microsoft.com/kb/948349, but that solution is for a > different > OS.) > > To avoid this error I need to uncheck the "collate" option in the Print > dialog box. Fine. > > Is there any way I can get Excel to always leave that option unchecked? > As > it is, the option is always checked, even if I have just printed the > document > with it unchecked. > > Obviously I could create a simple macro to print 6 copies, uncollated. > But > I sometimes need 2 copies, sometimes 20, so a macro isn't an easy fix. > > Any suggestions? >