Hi O_lanke,

My Excel does not have iteration ticked off as default in the
tools/options/calculation. But why can not this be done with VB upon
start of Excel ?

As Tom suggested, for some reason, that property can only be set when
there is a workbook active. You could, therefore, use:

Dim wkbTemp As Workbook

Set wkbTemp = Workbooks.Add
Application.Iteration = True
wkbTemp.Close False

with Application.ScreenUpdating switched off to avoid the flickering.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk