Solved

can not staple microsoft excel print jobs

Posted on 2006-06-22
2
2,591 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to solve seemingly unsolvable printer issues. Users sometimes run into printing issues where all the normal steps do not seem to work. Well the steps below can show users how to take one extra step beyond the normal steps needed to remove old…
This seems to be a very common error related to the Samsung printer driver. First, this is the error we're talking about: Log: System Type: Error Event: 7000 Agent Time: 3:37:24 am 22-Apr-09 Event Time: 6:07:24 pm 21-Apr-09 UTC Source: Se…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

685 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