Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Printer Collate
Since installing Office 2007, the collate box when I go to print doesn't stay checked (like it always did in 2003). Is there something wrong with the program or is that the default. If it is the new excel default, how do I change it. I am always printing many copies of a file and need it collated. -- Lee Morgenstein |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Printer Collate
Hi Lee,
In Excel 97, 2000, 2002, 2003, the Collate check box in the print dialog box is checked by default. In versions of Microsoft Excel earlier than Excel 97, in Excel 2007, the Collate check box is cleared by default. If you want this option checked by default in the new Excel files, we can create a template and put it into the XLSTART folder to work around it. Following is the key steps. Note: As this setting is saved with the workbook, the following steps doesn't affect the existing workbooks. 1. Open a new blank workbook in Excel 2007. 2. Click the Office button Print. 3. In the print dialog box, click Properties in the Advanced tab, go to Paper/Output. Click Copy Count, set it as 2, and check the Collate. If you want the copy count as 1, then set it back to 1. Click OK. Now, the collate is checked. Click Close. 4. Click the Office button Save As. Choose file type as *.xltx. Save it to the folder: C:\Program Files\Microsoft Office\Office12\XLSTART. Name the file as book.xltx. 5. Click Save to save it. 6. Exit Excel. Start Excel 2007. Check the print dialog box in the new Excel file. The collate checkbox should be checked. What is the result? Related KB article: 822107 How to use startup folders in Excel http://support.microsoft.com/default...b;EN-US;822107 If anything is unclear or if you have any other concerns, please don't hesitate to contact me. Regards, Emily Lin Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ================================================== == When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ================================================== == This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- Thread-Topic: Printer Collate thread-index: Acg2oU4sTvcaqFUsSbebNvL30ycg0Q== X-WBNR-Posting-Host: 207.46.192.207 From: ?B?TGVl?= Subject: Printer Collate Date: Tue, 4 Dec 2007 10:13:00 -0800 Lines: 8 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Newsgroups: microsoft.public.excel.setup Path: TK2MSFTNGHUB02.phx.gbl Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:1961 NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149 X-Tomcat-NG: microsoft.public.excel.setup Since installing Office 2007, the collate box when I go to print doesn't stay checked (like it always did in 2003). Is there something wrong with the program or is that the default. If it is the new excel default, how do I change it. I am always printing many copies of a file and need it collated. -- Lee Morgenstein |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Printer Collate
Thank you very much Emily, That was very helpful. One quick question. Do you
think there is a way to create a batch file that I can apply to Excel files already created? -- Lee Morgenstein "Lee" wrote: Since installing Office 2007, the collate box when I go to print doesn't stay checked (like it always did in 2003). Is there something wrong with the program or is that the default. If it is the new excel default, how do I change it. I am always printing many copies of a file and need it collated. -- Lee Morgenstein |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Printer Collate
Hi Lee,
Appreciate your update and response. I am glad to hear that the information is helpful. I am sorry but I am not familar with the coding/creating batch files. For assistance with this coding issue, you can post it on the MSDN newsgroups for peer experiences and recommendations. I have provided link as below: http://msdn.microsoft.com/newsgroups/default.asp If you have any other questions or concerns, please do not hesitate to contact me. It is always my pleasure to be of assistance. Have a nice day! Emily Lin, Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ================================================== ==== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ================================================== ==== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- Thread-Topic: Printer Collate thread-index: Acg3tVlZ5hxBv5KXTqev5LWQMRuBPw== X-WBNR-Posting-Host: 207.46.19.197 From: ?B?TGVl?= References: Subject: Printer Collate Date: Wed, 5 Dec 2007 19:09:00 -0800 Lines: 17 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Newsgroups: microsoft.public.excel.setup Path: TK2MSFTNGHUB02.phx.gbl Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:1970 NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149 X-Tomcat-NG: microsoft.public.excel.setup Thank you very much Emily, That was very helpful. One quick question. Do you think there is a way to create a batch file that I can apply to Excel files already created? -- Lee Morgenstein "Lee" wrote: Since installing Office 2007, the collate box when I go to print doesn't stay checked (like it always did in 2003). Is there something wrong with the program or is that the default. If it is the new excel default, how do I change it. I am always printing many copies of a file and need it collated. -- Lee Morgenstein |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
Printer Collate
Thank you Emily
-- Lee Morgenstein "Emily Lin" wrote: Hi Lee, Appreciate your update and response. I am glad to hear that the information is helpful. I am sorry but I am not familar with the coding/creating batch files. For assistance with this coding issue, you can post it on the MSDN newsgroups for peer experiences and recommendations. I have provided link as below: http://msdn.microsoft.com/newsgroups/default.asp If you have any other questions or concerns, please do not hesitate to contact me. It is always my pleasure to be of assistance. Have a nice day! Emily Lin, Microsoft Online Partner Support Get Secure! - www.microsoft.com/security ================================================== ==== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ================================================== ==== This posting is provided "AS IS" with no warranties, and confers no rights. -------------------- Thread-Topic: Printer Collate thread-index: Acg3tVlZ5hxBv5KXTqev5LWQMRuBPw== X-WBNR-Posting-Host: 207.46.19.197 From: ?B?TGVl?= References: Subject: Printer Collate Date: Wed, 5 Dec 2007 19:09:00 -0800 Lines: 17 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Newsgroups: microsoft.public.excel.setup Path: TK2MSFTNGHUB02.phx.gbl Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.excel.setup:1970 NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149 X-Tomcat-NG: microsoft.public.excel.setup Thank you very much Emily, That was very helpful. One quick question. Do you think there is a way to create a batch file that I can apply to Excel files already created? -- Lee Morgenstein "Lee" wrote: Since installing Office 2007, the collate box when I go to print doesn't stay checked (like it always did in 2003). Is there something wrong with the program or is that the default. If it is the new excel default, how do I change it. I am always printing many copies of a file and need it collated. -- Lee Morgenstein |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collate data from many workbooks | Excel Discussion (Misc queries) | |||
printer collate box unchecked in excel | Excel Discussion (Misc queries) | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
How do you disable the Collate button? | Excel Discussion (Misc queries) |