+ Reply to Thread
Page 2 of 2
FirstFirst 1 2
Results 11 to 13 of 13

Thread: MS Excel on iR2200-3300

  1. #11
    Technician Choro1dal is on a distinguished road
    Join Date
    Jun 2008
    Location
    Bournemouth,Dorset
    Posts
    23
    Rep Power
    4
    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

  2. #12
    Senior Tech 100+ Posts mitsubee is an unknown quantity at this point mitsubee's Avatar
    Join Date
    Jul 2007
    Location
    Georgetown
    Posts
    162
    Rep Power
    0
    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

  3. #13
    Technician Choro1dal is on a distinguished road
    Join Date
    Jun 2008
    Location
    Bournemouth,Dorset
    Posts
    23
    Rep Power
    4
    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.

+ Reply to Thread
Page 2 of 2
FirstFirst 1 2

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts