A peculiar PDF from Excel problem

I can PDF a full Excel file without problems.

But if I copy in a worksheet from another workbook, then when I come to PDF
that file, it will no longer print the whole workbook at once - it will do a
few pages up until the copied in sheet, then it will ask for another save
location, and it will make a new file.

I've had the same problem with Distiller and PDF Writer - if anyone has
encountered this problem or can suggest a solution, I'd be very grateful.

Daniel

Does that still happen if you save, close, then reopen the workbook?

On Thu, 17 Mar 2005 11:39:04 -0800, "Daniel Bonallack"
<DanielBonallack@discussions.microsoft.com> wrote:

>I can PDF a full Excel file without problems.
>
>But if I copy in a worksheet from another workbook, then when I come to PDF
>that file, it will no longer print the whole workbook at once - it will do a
>few pages up until the copied in sheet, then it will ask for another save
>location, and it will make a new file.
>
>I've had the same problem with Distiller and PDF Writer - if anyone has
>encountered this problem or can suggest a solution, I'd be very grateful.
>
>Daniel

Yeah, we tried that. It's just bizarre...

"Myrna Larson" wrote:

> Does that still happen if you save, close, then reopen the workbook?
>
> On Thu, 17 Mar 2005 11:39:04 -0800, "Daniel Bonallack"
> <DanielBonallack@discussions.microsoft.com> wrote:
>
> >I can PDF a full Excel file without problems.
> >
> >But if I copy in a worksheet from another workbook, then when I come to PDF
> >that file, it will no longer print the whole workbook at once - it will do a
> >few pages up until the copied in sheet, then it will ask for another save
> >location, and it will make a new file.
> >
> >I've had the same problem with Distiller and PDF Writer - if anyone has
> >encountered this problem or can suggest a solution, I'd be very grateful.
> >
> >Daniel
>
>