Iteration frustration

[sharkfoot]

I have a workbook that has an issue with a circular reference. I figured
out to goto OPTIONS, CALCULATIONS, then select the ITERATION checkbox
and that fixes the problem, but I save and close the workbook and the
problems returns. The iteration checkbox is no longer checked and excel
tell me there is a problem with a circular reference again.

How do I get the iteration checkbox to remain checked when the workbook
is reopened? I tried this:


Code:

 

[sharkfoot]

I forgot to mention that there are three circular references in this
workbook, all on the same sheet. Not sure if that matters but I figured
I'd mention it just in case.

 

[sharkfoot]

Here is the workbook so you can see what I see...


+-------------------------------------------------------------------+
|Filename: lease.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4515 |
+-------------------------------------------------------------------+