Force circular reference
 

Oh wise ones,
I have a file that constantly updates. I have some
circular references in the file and have set up my options to allow for 1
iteration which I have read would allow for this. The problem is sometimes
when I open the file the circular reference option is turned off. Is what
can I do to prevent this. Is it like the calculation manual/auto issure where
you can force one or the other in a workbook open event? If so, what would
the syntax be?

Thanks,
Mike

Hi Mike,

Iteration, like the other Calculation Options, is an Excel-wide setting. If
you open a workbook that has iteration disabled, and then open another one,
it will be disabled in that one too, no matter how it was saved.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Mike K" wrote in message
...
Oh wise ones,
I have a file that constantly updates. I have some
circular references in the file and have set up my options to allow for 1
iteration which I have read would allow for this. The problem is sometimes
when I open the file the circular reference option is turned off. Is what
can I do to prevent this. Is it like the calculation manual/auto issure
where
you can force one or the other in a workbook open event? If so, what
would
the syntax be?

Thanks,
Mike

Nick,
So if I force automatic calculation by the code below, what can I use to
force a circular reference when a workbook is opened.

Application.Calculation = xlCalculationAutomatic

Mike

"Niek Otten" wrote:

Hi Mike,

Iteration, like the other Calculation Options, is an Excel-wide setting. If
you open a workbook that has iteration disabled, and then open another one,
it will be disabled in that one too, no matter how it was saved.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Mike K" wrote in message
...
Oh wise ones,
I have a file that constantly updates. I have some
circular references in the file and have set up my options to allow for 1
iteration which I have read would allow for this. The problem is sometimes
when I open the file the circular reference option is turned off. Is what
can I do to prevent this. Is it like the calculation manual/auto issure
where
you can force one or the other in a workbook open event? If so, what
would
the syntax be?

Thanks,
Mike

Hi Mike,

The Macro recorder gave this:

With Application
.Iteration = True
.MaxIterations = 1
.MaxChange = 0.001
End With


--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Mike K" wrote in message
...
Nick,
So if I force automatic calculation by the code below, what can I use to
force a circular reference when a workbook is opened.

Application.Calculation = xlCalculationAutomatic

Mike

"Niek Otten" wrote:

Hi Mike,

Iteration, like the other Calculation Options, is an Excel-wide setting.
If
you open a workbook that has iteration disabled, and then open another
one,
it will be disabled in that one too, no matter how it was saved.

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Mike K" wrote in message
...
Oh wise ones,
I have a file that constantly updates. I have some
circular references in the file and have set up my options to allow for
1
iteration which I have read would allow for this. The problem is
sometimes
when I open the file the circular reference option is turned off. Is
what
can I do to prevent this. Is it like the calculation manual/auto issure
where
you can force one or the other in a workbook open event? If so, what
would
the syntax be?

Thanks,
Mike