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:
--------------------
Private Sub Workbook_Open()
Application.Iteration = True
End Sub
--------------------


But the problem remains. Ideas?


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=525833