RE: printing to a pdf file

Randy -

Excel treats them as separate print jobs if the worksheets have different
page set-ups - for example the first four pages are set-up as Portrait and
the last two in Landscape.
I do not know of a workaround where it will print them to one file.

Anyone?



"Randy Starkey" wrote:

> Hi,
>
> I have a workbook of 6 sheets. When printing to a pdf file, it prints the
> first 4 sheets and then wants to do a separate file for the next 2 sheets.
> This only happens on one xls file I have. Anyone know what could be causing
> this? Excel 2003 on WinXPSP2
>
> Thanks!
>
> --Randy Starkey
>
>
>

I just started using a software product called pdf995 (www.pdf995.com). The
default is that each print job is a separate file, however there is a setting
in the ini file that can be changed that would then print remaining print
jobs to the same pdf.


"CSCobb" wrote:

> Randy -
>
> Excel treats them as separate print jobs if the worksheets have different
> page set-ups - for example the first four pages are set-up as Portrait and
> the last two in Landscape.
> I do not know of a workaround where it will print them to one file.
>
> Anyone?
>
>
>
> "Randy Starkey" wrote:
>
> > Hi,
> >
> > I have a workbook of 6 sheets. When printing to a pdf file, it prints the
> > first 4 sheets and then wants to do a separate file for the next 2 sheets.
> > This only happens on one xls file I have. Anyone know what could be causing
> > this? Excel 2003 on WinXPSP2
> >
> > Thanks!
> >
> > --Randy Starkey
> >
> >
> >