I have a spreadsheet with a circular reference that cant be avoided. I have
tick Iteration so there are no errors and Excel calculates correctly. However
when other colleges open the document they have to tick the Iteration box
again. Can you set Iteration so it is permanently on?

You would have to save the workbook with workbook_open code to set
iterations on when that particular workbook is opened.

Then beforeclose or deactivate code to turn it back on when workbook is
closed or another workbook is activated.

Can't you re-structure to prevent the "unavoidable" circ ref?


Gord Dibben MS Excel MVP


On Thu, 17 Dec 2009 07:35:02 -0800, M wrote:

I have a spreadsheet with a circular reference that can’t be avoided. I have
tick Iteration so there are no errors and Excel calculates correctly. However
when other colleges open the document they have to tick the Iteration box
again. Can you set Iteration so it is permanently on?