Solved

can not staple microsoft excel print jobs

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

Suggested Solutions

Title # Comments Views Activity
HP 2605 printer issues 10 139
lost printers in remote desktop 8 45
Printing not working on a Toshiba eStudio 232 12 88
DNS records 18 83
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

930 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now