Which application are you using to print to PDF?
Some versions of Adobe Acrobat split each workbook into a separate PDF file for
each worksheet.
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
Gord Dibben MS Excel MVP
On Fri, 8 Dec 2006 13:10:01 -0800, DuaneD77
wrote:
If I move a worksheet from another Excel workbook or if I export a new
worksheet into Excel from Quickbooks, sometimes when I try to print to a pdf
file, it tries to split the file up in peices? anyway to correct a file in
this situation?