Maximum Iterations changing without reason....

[gidsy]

Hi,

I have created a template and set the max iterations for calculation to 1000 and the max change to 0.01. This works fine.

When I do some development on the template these numbers change. e.g. I updated a couple of formulas and when I looked at the iteration settings they had changed without me doing anything. I am the only one with access to the template.

Does Excel change these settings? Also, is there a way of locking them down?

Thanks in advance...