Answered
I am using Adobe Pro 9. Excel 2003.
Most of my excel docs are set up as letter/8.5 x 11.
When I want to PDF while in excel, I will click on file, print to bring up my printer list and I have Adobe PDF listed.
I have to click on properties each time and change the Adobe PDF Page Size from 11x17 to Letter.
I have gone into all of these areas to try and change the default size but it does not seem to stay.
1. Edit, Preference, New document: Default Page Size: Letter
2. File, Print, Adobe PDF, Properties, Layout, Advance, Page Size
3. Start, Settings, Printer and Faxes, Right click on Adobe PDF, Properties, Advanced, Printer Defaults.
Nothing seems to be able to keep the default.
thanks, Lynda
Edit > Preferences > select Category "Convert To PDF"
In the 'Converting To PDF' list, scroll to and select Microsoft Office Excel.
Click on the [Edit Settings] button.
In the 'Adobe PDF Settings for supported documents' dialog,
observe the selected Distiller job option (default is 'Standard') that is present as the value for "Adobe PDF Settings:"
Click on the adjacent [Edit] button.
Adobe Distiller's 'Adobe PDF Settings' dialog appears.
The 'General' settings show by default.
See if the Default Page Size is other than what you want.
Edit if needed and "Save As" to give yourself a new Distiller job option.
Something else to note.
In a job option's 'General' section you can also set the desired PDF Version that you want the Distiller output PDF to be.
Whenever you process "input" through this Distiller job option the output PDF will be of the selected PDF Version.
Note that older versions will not have features unique to a newer version.
With Acrobat onboard, when you "print to PDF" or use the PDFMaker, the source "input" is going to go through a Distiller job option.
Getting this "input" lined up to pass through the desired job option assures you get what you expected.
As you noted, changing the selected job option via Acrobat -
File > Print > Properties ...
will persist only for the time Acrobat is open. Close Acrobat, reopen, & Acrobat pulls its default, not what you edited earlier.Consider opening Adobe Distiller.
Click Settings > Edit Adobe PDF Settings
What is now displayed is the configuration setup for the job option that was shown in the previous dialog's "Default Settings".
That's ok. Look through General, Images, Fonts, Color, Advanced, & Standards if curious.
Or, at bottom left, check the 'Show All Settings" and select "Standard" (if not already shown).
In 'General' set desired Default Page Size and desired Compatibility (PDF Version).
Do a Save As & give the new job option a unique name (i.e., jo_Excel).
Back out of Distiller.
Now, go into the 'Printers' section of Windows.
XP:
(XP) Start > Printers and Faxes >
(Vista) Start > Control Panel > Hardware and Sound > PrintersSelect Adobe PDF
Right Click > select Properties
In the dialog that appears, locate and click on the button [Printing Preferences].
In the Adobe PDF Printing Preferences dialog:
Observe value for 'Default Settings' - use drop-down menu to select "jo_Excel'.
Click OK.
Back in the Adobe PDF Properties dialog -
Click on Advanced tab.
Locate and click on the [Printing Defaults] button.
Use the 'Default Settings' drop-down to select "jo_Excel".
Select OK.
Note that performing one of the two steps above does not change what is "held" in the other step.
So, do both.
Last but not least; make "Adobe PDF" your default printer driver (printer).
Windows applications, particularly MS Office applications are immediately aware of the designated default printer when they "wake up".
The application executes your layout, format, etc. directions in context of this awareness.
Changing printer (printer drivers) can & often does affect the print job output.
May be minor and not noticed. May be significant.
Most times, most print output (imprint to paper or content into PDF) may have [i]something[/i] affected.
So, if you are making PDF files each day you would benefit from having Adobe PDF as your default printer.
Or, if you know that, for a particular work session, you are going to output PDF, then make Adobe PDF the default
before opening any application(s).
Whenever you need to print to a local or network printer, select it from the print dialog.
Regardless, whenever changing the printer from whatever is the default, always do the application appropriate
"update" of fields, macros, etc. to get the application (and the open file) 'aligned' to the new printer.
Be well...
Be well...