Iterate Circular Reference

[Brandt]

I have one workbook where (due to necessity) I have it set to interate
circular references. If I save the changes made to this workbook and close
it (but not excel) and then open a new workbook the setting is now on for
iterations to be made on any circular references that are created. As such,
I am not informed that I have created a circular reference in the new
workbook. Is there a way to never have this setting on with a new workbook?

Thanks for any help.

 

[Biff]

Hi!

Iteration is a global setting. If the very first wb you open during an Excel
session is set to allow iteration, every wb you open thereafter during that
session will also be set to allow iteration. When you are done with this
particular file and close it, also close Excel. Then reopen Excel and you
should be good to go.

Biff