a printer is connected multiple times in windows using different names,
each with different default settings (paper tray, color, etc). When I
change the printer in Excel, e.g. from the "letterhead tray" printer to
the "A3 paper" printer, the corresponding tray settings are not
changed. Other applications (Word, Internet Explorer) correctly apply
the settings when changing the printer, it seems to be just Excel
(Office 2003 SP2) that does not.
Is there a way to get Excel to apply the printer settings (other than
changing from the default printer to a completely different printer and
_then_ to the printer with the desired setting; we use this as a
workaround at the moment)?