MS Excel on iR2200-3300

[mitsubee]

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

[mrfixit51]

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?

[bnmand]

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)

[mata]

Go to Printing prefernces->paper source and set paper selection to "Same paper for all pages"

[mitsubee]

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

[bnmand]

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).

[mitsubee]

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

[mrfixit51]

Looks like you answered your own question...

....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!

[mitsubee]

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]

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

[Choro1dal]

This issue rears its ugly head quite often and is not restricted to tray designation or manufacturer. Essentially the application settings over-ride those of the print driver. Prior to printing the entire set of worksheets within the spreadsheet you should ensure that the page set up for each sheet is configured the same.

I have cut and pasted the following which I hope helps.

Workaround/Solution
The easiest workaround is to print each worksheet separately.
However, if you take both of the 2 behaviors (listed below) into account, you might be able to configure settings that will produce the desired results. The exact configuration depends on the results you are trying to achieve.
Information
How Excel works when printing
There are 2 behaviors to consider in determining what the output of an Excel job will look like.
Behavior 1) When driver settings are changed in Excel, the change will only be applied to the currently active worksheet.
Reference: MS knowledge base article Only first worksheet prints duplexed
Behavior 2) Excel sends 2 neighboring sheets (i.e. sheet1 and sheet2) to the driver as a single job if all of the following settings are the same. If they are not the same, the worksheets will each be a seperate job.
- Resolution
- Color mode (Color / Black and White) (Note: PCL5c drivers of some models will not be affected by this setting.)
- Copies
- Duplex
Reference: MS knowledge base article Unexpected behavior when you use different print quality for sheets in Excel

[mitsubee]

Dear Choro ,first thank you for replying,


When driver settings are changed in Excel, the change will only be applied to the currently active worksheet.

i wonder can we change to specific drawer to print by clicking every sheet and change the tray destination or it will be the same...well i go and check it tomorrow.

thanks again choro

[Choro1dal]

Hi Mitsubee,

Thats correct, you need to configure the print set up for each workbook in the spreadsheet. Alternatively you could create a 'group' ofworksheets and apply the settings to it.