It did work on the Canon printer, but I guess that's no guarantee
it will work on all printers, as you have pointed out.
    Tom

Roy Brown wrote:
|| In message <002a01c39813$efd52630$3e01a8c0@Tom>, Tom Hula
|| <[log in to unmask]> writes
||| Thanks for the suggestions. I ended up getting the following
||| information and suggestion from the vendor (Canon). Since
||| it appears to be a Microsoft problem, I thought I'd pass it
||| along:
|||
||| Title: Problems Printing with Finishing Options from a
|||        Multiple Worksheet Microsoft Excel Job
||
|| <snip what Canon fired off>
||
||| Tom Hula wrote:
||||| We have a spreadsheet from a vendor that we then
||||| modified for our purposes. Each page is on a seperate
||||| worksheet in one workbook. We want to print the whole
||||| workbook double-sided, but it will only print
||||| single-sided, as if it were (in effect) printing
||||| a seperate file for each page in each worksheet. Is
||||| there any way to print the workbook and have it print
||||| double-sided?
||
|| Hi Tom
||
|| But does it work, even with the above?
||
|| I tried this this morning with a multi-sheet book, got the problem
|| described (though I thought it was me, not Excel 2000), and set the
|| print options on all the sheets as described.
||
|| But it still started a new 'odd-numbered' page for each worksheet,
|| not just a new page. That I take as a function of each worksheet
|| being a separate job; even though the fix above makes the second and
|| subsequent worksheets print duplex, each new job throws to a new
|| sheet of paper, not just to a new page (which could easily be the
|| back of something not related to your task - think multi-user print
|| queue, or just think unused last page of your last worksheet).
||
|| And as you have each page on a separate worksheet, I think you'll
|| still get single-sided printing.
||
|| Mind you, I'm on a Sharp, not a Canon, and I only figured/used the
|| PCL workaround, though it does have Postscript...
||
|| For the same reason, I'm sceptical of Wirt's 'hard-setting' solution,
|| which may well lock duplex on, but can't, I think, stop Excel
|| sending a (paper) page throw after each worksheet.
||
|| Though I'm happy to be contradicted by a practical experiment, I fear
|| that your solution may have to be that when modifying the spreadsheet
|| for your purposes, you amalgamate all the worksheets onto a single
|| worksheet, and print that.
||
|| As (I take it) the size of each page is known and consistent, unless
|| you are using shrink to fit, perhaps, it ought to be possible to
|| create an extra worksheet with blocks of formulae e.g.
||
||   =Sheet1!A1
||                          thru
||                                        =Sheet1!Z99
|| (Page throw)
||   =Sheet2!A1
||                          thru
||                                        =Sheet2!Z99
|| (Page throw)
|| =Sheet3!A1
||                          thru
||                                        =Sheet3!Z99
|| (Page throw)
||
|| and so on....
||
|| This will then auto-populate as the underlying Sheets1-n populate,
|| and can be the worksheet you use to print a duplex copy of the whole
|| thing.
||
|| HTH
||
||
||
|| --
|| Roy Brown        'Have nothing in your houses that you do not know
|| to be Kelmscott Ltd     useful, or believe to be beautiful'  William
|| Morris
||
|| * To join/leave the list, search archives, change list settings, *
|| * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *