Gavin,

Put this line into the workbook open event of all your workbooks:

Application.MaxIterations = 9999

HTH,
Bernie
MS Excel MVP


"Gavin Bulman" wrote in message
...
I wish the default number of iterations within ALL my excel spreadsheets to
be set at the maximum number viz. 9999. Presently, whenever saved
spreadsheets are recalled they have reverted to the default of 100 iterations
irrespective of the fact that at the time of saving them the iteration
frequency level had been changed to 9999. Please, can anyone help! Thanks
Gavin Bulman