Excel unchecks iteration

  • Thread starter Thread starter rods11
  • Start date Start date
R

rods11

We are having trouble with excel XP.
I try to convince excel that I need a fixed numver of iterations
(1 000), but evry time I restart the system and I open excel, the
iteration box is unchecked and the number is 100 again.

Does anyone know a trick to keep the prefere iteration settings?
 
Iteration is set by the first workbook that's opened, and remains so for any
other workbooks additionally opened, regardless of the setting that was
saved with those workbooks. Strikes me as a design oversight. If your
workbook was saved with Iteration on, and it's the first workbook you open
after starting Excel, Iteration should be on. Or you can put in a macro
that turns it on when you open your workbook:

Private Sub Workbook_Open()
With Application
.Iteration = True
.MaxChange = 0.001
End With
End Sub

Put this in module ThisWorkbook.
 
Back
Top