[simmerdown]

Is there a limit to the number of worksheets that can be converted to PDF
format?

If so, is there a way to increase the number?

Thanks.

[Hutch]

No. It might ask you to saves certain sheets as a different file name if the
page formatting for a particular sheet is different than another sheet in the
workbook.

"simmerdown" wrote:

Is there a limit to the number of worksheets that can be converted to PDF
format?

If so, is there a way to increase the number?

Thanks.

[Gord Dibben]

And which application would you be using to create the PDF files?

I have had success with the free file downloads and instructions for use here
at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

See also David McRitchie's site for alternatives to the above.

http://www.mvps.org/dmcritchie/excel/pdf.htm

Others have reported that PrimoPDF does a good job and is free.


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 06:37:03 -0700, simmerdown
wrote:

Is there a limit to the number of worksheets that can be converted to PDF
format?

If so, is there a way to increase the number?

Thanks.