Hi Hilmar,

This works for me:

.....
with objExcel.ActiveSheet
      .DisplayPageBreaks =.f.
      .PageSetup.zoom =  60  && or whatever
      .DisplayPageBreaks =.t.
endwith

>After changing the scale factor for printing an Excel sheet (created through Automation), the user still sees the old pagebreaks. After the user does a print preview, the pagebreaks on the main sheet are adjusted, but this is quite awkward a method. How can I force Excel to adjust the pagebreaks immediately?
>
>TIA,
>
>Hilmar.