Set Iteration on permanently

M

M

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top