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 *