Tech forums for copier repair  

Go Back   Copytechnet.com > Technical Forums > Fax & Printer Technical Discussion > Canon

MS Excel on iR2200-3300

Canon

Reply

 

LinkBack Thread Tools Display Modes
Old 06-24-2009   #1 (permalink)
Senior Tech
100+ Posts
 
mitsubee's Avatar
 
Join Date: Jul 2007

Malaysia
Location: Georgetown
Posts: 163
Rep Power: 0mitsubee is an unknown quantity at this point
MS Excel on iR2200-3300

Hello all fellows techs and engineers,

I recently found out a problem that is only with MS Excel Printing with iR3300.

Example:-
I created an excel document with 5 spreadsheet on it.

Spreadsheet 1 = 3 pages
Spreadsheet 2 = 1 page
Spreadsheet 3 = 4 pages
Spreadsheet 4 = 2 pages
Spreadsheet 5 = 3 pages

Now i wanna print to a iR3300 but only using Drawer 2.
Machine Drawer setup is

1st Tray = A4 ( Plain NEW )
2nd Tray = A4 ( Draft Papers )

Here is the problem.... once it start to print...
It will take 3 pieces from 2nd Tray ( Draft paper ) then 1 piece from 1st Tray ( Plain NEW ) then 4 piece from 2nd Tray again and so on...

So what i meant is ... why each time printing jobs jump from 1st spreadsheet to other spreadsheet it will jump tray too even i choose only wanted to print using the drawer 2....OK if i only choose 1 spreadsheet to print to specified drawer then i work great.Only when you choose to print out from all spreadsheet then tray jumping is going to occur.

Does anyone came across this issue before..... any solution or setting in excel ?

thanks for reading

Last edited by mitsubee; 06-24-2009 at 05:02 PM.. Reason: Left out something
mitsubee is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 06-24-2009   #2 (permalink)
Lead Service Technician
250+ Posts
 
mrfixit51's Avatar
 
Join Date: Oct 2008

United States us iowa
Location: Davenport, Iowa
Posts: 485
Rep Power: 7mrfixit51 will become famous soon enough
first a question..

I am not sure what is meant by draft paper,,, is this something that has already been printed to or copied on,, what I would refer to as scrap paper?? Also, if you know you have this problem, why not just pop out the top drawer while you print this scenario, to keep the machine from sourcing from the top drawer? This problem seems familiar to me,,, have you posted about this in the past?
mrfixit51 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #3 (permalink)
Service Manager
250+ Posts
 
Join Date: Sep 2008

Australia au victoria
Location: Victoria
Posts: 304
Rep Power: 6bnmand is on a distinguished road
Another question, which version of Excel are you using? Have you tried printing using a different version of Excel? What type of print drivers are you using?

Also take a look at your thread (that mrfixit51 remerbered) http://www.copytechnet.com/forums/ca...r-feeding.html

For the implications of changing APS/ADS settings see the user manuals (copy and reference guides)

Last edited by bnmand; 06-25-2009 at 01:57 AM..
bnmand is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #4 (permalink)
Technician
 
Join Date: Mar 2009

Serbia
Location: Belgrade
Posts: 16
Rep Power: 2mata is on a distinguished road
Send a message via Skype™ to mata
Go to Printing prefernces->paper source and set paper selection to "Same paper for all pages"
mata is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #5 (permalink)
Senior Tech
100+ Posts
 
mitsubee's Avatar
 
Join Date: Jul 2007

Malaysia
Location: Georgetown
Posts: 163
Rep Power: 0mitsubee is an unknown quantity at this point
Dear Mrfixit , bro bnmand and mata ...... the machine works just fine to all softwares words , adobe etc.... only excel.

1.i'll reply to Bro Mrfixit first : No i never post this before as i just found out the problem.
AGREE : on popping out the drawer on this scenario.but customer cant accept it as this is the fastest way of printing all spreadsheet at one time ( hold control + click on all spreadsheet tabs ).MrfixIt popping out the drawer will make the machine halted and asking for papers for other drawer. It works great when u are printing on 1 tab of spreadsheet no matter how many page there is.

2. Bro bnmand : MS excel 2007 and 2003 all same giving same problem.Canon v6.10 latest driver.

3.Bro mata : Same paper for all pages is the default setting on the driver..same problem.

Only solution the customer is seeking is...to print multi tabs spreadsheet to a specific drawer .... dont jump tray after 1 spreadsheet finish.

Thanks bro mrfixit bro bnmand and bro mata for the reply
mitsubee is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #6 (permalink)
Service Manager
250+ Posts
 
Join Date: Sep 2008

Australia au victoria
Location: Victoria
Posts: 304
Rep Power: 6bnmand is on a distinguished road
Did you read the suggestions in the other thread you started that I linked to?

Additional Functions > Common Settings > Store Paper Type.

You could try setting a different paper type for drawer 2 e.g. if your draft tray contains recycled paper set that.

Also try changing APS/ADS settings.

Also if Page Size is "A4", Select Output size also as "A4" (not match paper size).
bnmand is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #7 (permalink)
Senior Tech
100+ Posts
 
mitsubee's Avatar
 
Join Date: Jul 2007

Malaysia
Location: Georgetown
Posts: 163
Rep Power: 0mitsubee is an unknown quantity at this point
Bro about the machine setting all i already do.... every paper size or paper type setting at driver nor at machine itself i have tried....i even tried on all the machine there is in my office workshop..aroun 6 of them i print the same document i save from customer pc...all machine facing same problem.... bro bnmand do you suspect excel is creating this problem...i dont have problem with words , pads , adobe's files .... only excel that support multi tab spreadsheets....i wonder why machine jump have to jump tray when it jump spreadsheet tab to print....can you help me test it out from your office bro bnmand?

thanks
mitsubee is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-25-2009   #8 (permalink)
Lead Service Technician
250+ Posts
 
mrfixit51's Avatar
 
Join Date: Oct 2008

United States us iowa
Location: Davenport, Iowa
Posts: 485
Rep Power: 7mrfixit51 will become famous soon enough
Looks like you answered your own question...

Quote:
Originally Posted by mitsubee
View Post
....i even tried on all the machine there is in my office workshop..aroun 6 of them i print the same document i save from customer pc...all machine facing same problem.... bro bnmand do you suspect excel is creating this problem...
If you can create the same issue on multiple machines with the same result, then it can only be an application issue, out of the scope anything that can be remedied at the copier. Your issue lies within Excel, and my advice is to contact Microsoft help groups for the solution to this strange behavior.

have a great day!
mrfixit51 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-27-2009   #9 (permalink)
Senior Tech
100+ Posts
 
mitsubee's Avatar
 
Join Date: Jul 2007

Malaysia
Location: Georgetown
Posts: 163
Rep Power: 0mitsubee is an unknown quantity at this point
That`s the main thing i'm worried is Excel bro mrfixit.... that`s why i just wanna reconfirm if you guys could know in excel is there any setting that i dunno about maybe could set it , anyone here knows?

thanks

great day mrfixit
mitsubee is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-27-2009   #10 (permalink)
Senior Tech
100+ Posts
 
mitsubee's Avatar
 
Join Date: Jul 2007

Malaysia
Location: Georgetown
Posts: 163
Rep Power: 0mitsubee is an unknown quantity at this point
ohh yes by the way all bros....i'm trying to share this because it might land on you if one day your customer facing this problem......jumping tray when excel jumping spreadsheet tabs....maybe we could solve it here so everyone have an extra knowledge on this..

thanks bro
mitsubee is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
excel

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Google

All times are GMT +1. The time now is 01:32 PM.


Your Link Here
Toner Chip Resetter
Your Link Here

Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Ad Management plugin by RedTyger