Printing multiple portait and landscape workbooks at the same time

Hello all,
I have been having some serious issues trying to find a way to make
Excel print two worksheets at the same time (one is in portrait and the other
is in landscape). If the job travels through our print server to the
printer, it will come out as two print jobs (one in portrait and one in
landscape). If the job travels directly to the printer, the portrait and
landscape options will be valid, however the landscape side will have been
cropped to be 8.5" squared.
While this sounds like something I shouldn't be getting worked up over,
I am trying to duplex an Excel spreadsheet. Sheet1 is in portrait and Sheet2
is in landscape. If I print to through the print server, they come out as
two seperate pages. If I print directly to a printer, they come out as a
duplex document, one portrait and the other oriented in landscape but cropped
to be portrait (8.5 inches squared).
Here's the kicker! If I print to an Adobe PDF, it comes out just fine
(with page 1 as portrait and page 2 as landscape, no cropping). If I then
pass this job onto the printer, it prints fine. So I have determined that
the problem occurs when Excel is told to print to the printer itself.
However, trying 4 different models (3 HP LaserJets and one Lanier copy
machine), the same effects occur.
All Office 2003 updates have been downloaded from OfficeUpdate. I have
been able to reproduce this issue on any machine (I'm up to 5 PCs so far,
including Windows 2000 Pro SP3, SP4 and XP Pro SP2).

I am open to ANY suggestions. Anyone? Please? :-)

Thanks in advance.

Have you tried selecting both worksheets at the same time by holding down the
CTL key and then printing using the "print" icon?

"Sbaitso" wrote:

> Hello all,
> I have been having some serious issues trying to find a way to make
> Excel print two worksheets at the same time (one is in portrait and the other
> is in landscape). If the job travels through our print server to the
> printer, it will come out as two print jobs (one in portrait and one in
> landscape). If the job travels directly to the printer, the portrait and
> landscape options will be valid, however the landscape side will have been
> cropped to be 8.5" squared.
> While this sounds like something I shouldn't be getting worked up over,
> I am trying to duplex an Excel spreadsheet. Sheet1 is in portrait and Sheet2
> is in landscape. If I print to through the print server, they come out as
> two seperate pages. If I print directly to a printer, they come out as a
> duplex document, one portrait and the other oriented in landscape but cropped
> to be portrait (8.5 inches squared).
> Here's the kicker! If I print to an Adobe PDF, it comes out just fine
> (with page 1 as portrait and page 2 as landscape, no cropping). If I then
> pass this job onto the printer, it prints fine. So I have determined that
> the problem occurs when Excel is told to print to the printer itself.
> However, trying 4 different models (3 HP LaserJets and one Lanier copy
> machine), the same effects occur.
> All Office 2003 updates have been downloaded from OfficeUpdate. I have
> been able to reproduce this issue on any machine (I'm up to 5 PCs so far,
> including Windows 2000 Pro SP3, SP4 and XP Pro SP2).
>
> I am open to ANY suggestions. Anyone? Please? :-)
>
> Thanks in advance.

hodeware,

That is exactly what I am doing to cause the issue above. As I understand
it, since I am trying to duplex them, I must select them both using the
Ctrl+click in order to print at the same time.

Thanks.


"hodeware" wrote:

> Have you tried selecting both worksheets at the same time by holding down the
> CTL key and then printing using the "print" icon?
>
> "Sbaitso" wrote:
>
> > Hello all,
> > I have been having some serious issues trying to find a way to make
> > Excel print two worksheets at the same time (one is in portrait and the other
> > is in landscape). If the job travels through our print server to the
> > printer, it will come out as two print jobs (one in portrait and one in
> > landscape). If the job travels directly to the printer, the portrait and
> > landscape options will be valid, however the landscape side will have been
> > cropped to be 8.5" squared.
> > While this sounds like something I shouldn't be getting worked up over,
> > I am trying to duplex an Excel spreadsheet. Sheet1 is in portrait and Sheet2
> > is in landscape. If I print to through the print server, they come out as
> > two seperate pages. If I print directly to a printer, they come out as a
> > duplex document, one portrait and the other oriented in landscape but cropped
> > to be portrait (8.5 inches squared).
> > Here's the kicker! If I print to an Adobe PDF, it comes out just fine
> > (with page 1 as portrait and page 2 as landscape, no cropping). If I then
> > pass this job onto the printer, it prints fine. So I have determined that
> > the problem occurs when Excel is told to print to the printer itself.
> > However, trying 4 different models (3 HP LaserJets and one Lanier copy
> > machine), the same effects occur.
> > All Office 2003 updates have been downloaded from OfficeUpdate. I have
> > been able to reproduce this issue on any machine (I'm up to 5 PCs so far,
> > including Windows 2000 Pro SP3, SP4 and XP Pro SP2).
> >
> > I am open to ANY suggestions. Anyone? Please? :-)
> >
> > Thanks in advance.

if you have several responses from me I appologize, the computer is doing
wierd things today.
try changing the order of your work sheets.
on my printer , if I print the portrait first it will not even duplex, but
if I print the landscape first it duplexes just fine.

"Sbaitso" wrote:

> hodeware,
>
> That is exactly what I am doing to cause the issue above. As I understand
> it, since I am trying to duplex them, I must select them both using the
> Ctrl+click in order to print at the same time.
>
> Thanks.
>
>
> "hodeware" wrote:
>
> > Have you tried selecting both worksheets at the same time by holding down the
> > CTL key and then printing using the "print" icon?
> >
> > "Sbaitso" wrote:
> >
> > > Hello all,
> > > I have been having some serious issues trying to find a way to make
> > > Excel print two worksheets at the same time (one is in portrait and the other
> > > is in landscape). If the job travels through our print server to the
> > > printer, it will come out as two print jobs (one in portrait and one in
> > > landscape). If the job travels directly to the printer, the portrait and
> > > landscape options will be valid, however the landscape side will have been
> > > cropped to be 8.5" squared.
> > > While this sounds like something I shouldn't be getting worked up over,
> > > I am trying to duplex an Excel spreadsheet. Sheet1 is in portrait and Sheet2
> > > is in landscape. If I print to through the print server, they come out as
> > > two seperate pages. If I print directly to a printer, they come out as a
> > > duplex document, one portrait and the other oriented in landscape but cropped
> > > to be portrait (8.5 inches squared).
> > > Here's the kicker! If I print to an Adobe PDF, it comes out just fine
> > > (with page 1 as portrait and page 2 as landscape, no cropping). If I then
> > > pass this job onto the printer, it prints fine. So I have determined that
> > > the problem occurs when Excel is told to print to the printer itself.
> > > However, trying 4 different models (3 HP LaserJets and one Lanier copy
> > > machine), the same effects occur.
> > > All Office 2003 updates have been downloaded from OfficeUpdate. I have
> > > been able to reproduce this issue on any machine (I'm up to 5 PCs so far,
> > > including Windows 2000 Pro SP3, SP4 and XP Pro SP2).
> > >
> > > I am open to ANY suggestions. Anyone? Please? :-)
> > >
> > > Thanks in advance.

Just one response. :-)

I have tried printing in both orders with no effect. Keep in mind that it
is in fact duplexing (and it duplexes either way), but it is automatically
cropping off the right-hand edge whenever it duplexes the landscape page (to
make it the width of a portrait page).

Thanks again.


"bj" wrote:

> if you have several responses from me I appologize, the computer is doing
> wierd things today.
> try changing the order of your work sheets.
> on my printer , if I print the portrait first it will not even duplex, but
> if I print the landscape first it duplexes just fine.

I have a techtonix printer ???
If you don't have to do this too often, a workaround is to "copy as picture"
{shift <edit><copyas picture>) the section you want to be ladscape
paste it on page 3
rotate it and duplex.

"Sbaitso" wrote:

> Just one response. :-)
>
> I have tried printing in both orders with no effect. Keep in mind that it
> is in fact duplexing (and it duplexes either way), but it is automatically
> cropping off the right-hand edge whenever it duplexes the landscape page (to
> make it the width of a portrait page).
>
> Thanks again.
>
>
> "bj" wrote:
>
> > if you have several responses from me I appologize, the computer is doing
> > wierd things today.
> > try changing the order of your work sheets.
> > on my printer , if I print the portrait first it will not even duplex, but
> > if I print the landscape first it duplexes just fine.

We are primarily using HP printers (I've tried a LaserJet 5000, LaserJet
4100, LaserJet 8100 ). For kicks, I've also tried a Lanier 5645 copier. All
have produced the same results.

I appreciate the suggestion, however we need to print about 50 versions of
these stupid things. :-)

Thanks again.


"bj" wrote:

> I have a techtonix printer ???
> If you don't have to do this too often, a workaround is to "copy as picture"
> {shift <edit><copyas picture>) the section you want to be ladscape
> paste it on page 3
> rotate it and duplex.

I have been at this for a while now. :-)

Some interesting trends... I have narrowed the problem to Excel and not the
printers. The reason why I say this is because regardless of what printer
(or copy machine) I use, the print function from Excel spits out two jobs
into the print queue when I ask it to print either the group of workbooks
(using Ctrl + click) or print the entire workbook (choosing "Entire Workbook"
from the Print options). This includes printing to Adobe PDFs as well as the
MS Office Image Writer.

Additionally, it is something in the document that is doing this. I have
been copying and pasting the workbooks into a new Excel spreadsheet and they
have been working (somewhat).

Excel decides to split up the workbooks or else insert a blank page between
the workbooks, so that an otherwise two-page document becomes three pages.

This is getting weird and frusterating...