Solved

can not staple microsoft excel print jobs

Posted on 2006-06-22
2
2,519 Views
Last Modified: 2008-02-01
I am not able to staple my print jobs that I send using microsoft excel. I can staple any other types of files(doc,pdf,etc). The printer is a Ricoh 2060 copier/printer. I have it set up on a print server running windows 2000 server. I have tried to turn off collate on the application side and vice versa to see if that would help with no luck.
0
Comment
Question by:Mopep
2 Comments
 
LVL 38

Assisted Solution

by:hdhondt
hdhondt earned 250 total points
ID: 16964678
The problem may be that Excel always sends multiple copies of the job as separate print files, i.e. if you print 10 copies and check the print queue, you'll see 10 jobs there. Try setting the number of copies and turning on stapling from Printing Preferences or even from Printing Defaults. Make sure Excel is not running when you do this or it may not see the changes.

To find Printing Preferences go to Start > Printers and right-click on the printer. The copy counts should be under the Advanced button. For Printing Defaults, select Properties when you right-click, click on the Advanced tab and then on the Printing Defaults button
0
 
LVL 21

Accepted Solution

by:
wyliecoyoteuk earned 250 total points
ID: 16979945
As hdhondt says, Excel is a bit quirky with printing, often the page layout can cause it.

The stapling will only work if application collate is switched off.

In the printer driver, advanced tab, set spooling to "start printing after the last page has spooled" and untick "enable advanced printer features" this may help.

One solution  might be to export the file.
Openoffice

 http://www.openoffice.org

can read excel files, and often prints them OK (as long as there are no macros involved) it can also export them as PDFs, which can be printed from Acrobat reader.

Another option with the Ricoh 2060 is to send the print job to the document server, and then print the copies and apply the print settings from the copier screen.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Causes of paper jams:The following are the main causes of paper jams. Guides:If the guides for the paper are not set correctly they may cause the paper to enter at an angle. You should ensure that the guides are set correctly for the paper type a…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question