Hello Abraham,
did you make your setting from within Excel Print Properties? That might be
the reason. The trick to get rid of the saving prompt was to change the
printer properties in the Control Panel €“ Printers and Faxes €“ Adobe PDF €“
Properties €“ Printing defaults.
You cannot set these properties permanently within the properties in Excel,
as soon you have reset to your Standard Printer the options are selected
again.
Clear the selections for €œPrompt for Adobe PDF filename€� AND €œDo not send
fonts to €œAdobe PDF€�€�. Both are important, the latter for the driver to make
the Postscript files thatll be deleted after conversion to PDF-files.
Good luck


"Abraham Andres Luna" wrote:

the solution works but doesn't make sense.
you have to close the excel file and application then reopen it to print
another worksheet
this will stop the adobe pdf driver from prompting for filename when
printing more than one worksheet.