ITER: 1

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

On the lower left part of Excel the words "ITER: 1" appear
sporadically. This freezes my spreadsheet for an
instance. I need to have automatic calc on. What does
this "ITER: 1" do and can I stop it?
 
Dave

ITER: 1 probably means you have Tools>Options>Calculations>Iterations set to 1

Uncheck the "Iteration" box and see what happens.

Gord Dibben Excel MVP
 
Back
Top