I would include a macro that runs automatically when your workbook is opened.
The macro would save the state of iteration and then setup iteration
according to your model's needs.

Another macro would run automatically when the workbook is closed. The
second macro would restore the state of iteration.
--
Gary''s Student - gsnu201003


"Paolo" wrote:

Have a problem. I have to create a model which include some iterative
calculation, but the model is addressed to a large number of users and i
don't want the error message for circular references to appear when they open
it.
As far as i understand i can't create a template because it would be saved
on my machine. The file needs to work as it is on every computer.
I have noticed that if a user has already another Excel file open (without
the iteration box flagged) and they open my file the error message appears,
if they lunch my file and Excel is not opened is ok.

Any idea? Thanks!