the challenge is I am not using "print" at all I am using BI distribution using the option to convert each worksheet to static values as the recipients of my financial do not have Sage 300

the challenge is I am not using "print" at all I am using BI distribution using the option to convert each worksheet to static values as the recipients of my financial do not have Sage 300

You will have to hit "Print" when it is on your Sage 300 machine. Once you "Print to PDF" on your Sage machine, you can then send the PDF to your recipients. Doing things this way means that you avoid using the Distribute Tool completely since Printing to PDF essentially makes it static by definition.

thank you this was helpful.   Are you familiar with a free  "create PDF" that when you choose multiple worksheets and choose print active sheets it will generate a single PDF not multiple 1 page PDF's.   I am unable to use MS print to PDF because I am on a terminal server.  From your reply i am assuming MS print to PDF would have done this and I assume that in the full adobe suite you can likely do that.