Have a workbook open event macro that includes
Application.Iteration = True

If you do this, remember that it may leave Excel in this state the next time
Excel is openned
--
Gary's Student
gsnu200707


"Daiv" wrote:

I have put together an excel template for my office that uses circular
references. When i first opened it, it came up with the error pointing out
circular references and I needed to go into the calculation options and allow
the iterations. Then it worked fine.

My problem now is that if I save a file on my computer, and a coworker
tries to open it, they then get the circular reference problem again, even
though I can open it on my computer no problem. Once he saves it, I then
have the circular reference problem as well. and we go in "circles" with
this problem.

How can I make it so that it always allows the circular references no matter
who opens/saves the file?

Thank you!