Turn Off Circular Reference Message

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ryguy7272 - 18 Dec 2007 15:26 GMT

I am using a Circular Reference in one sheet in a workbook and keep getting
the Circular Reference message. Is there a way to turn this message off? I
am using the code below, but it doesn’t resolve the issue:

Private Sub Auto_Open()
On Error Resume Next
Application.DisplayAlerts = False
End sub

Regards,
Ryan--

Signature

RyGuy

Reply to this Message

JE McGimpsey - 18 Dec 2007 15:48 GMT

Tools/Options/Calculation, check Iteration.

> I am using a Circular Reference in one sheet in a workbook and keep getting
> the Circular Reference message. Is there a way to turn this message off? I
[quoted text clipped - 7 lines]
> Regards,
> Ryan--

Reply to this Message

ryguy7272 - 18 Dec 2007 16:09 GMT

Yes, that does the trick. For some reason, the default for Iteration seems
to be 'unchecked'. I seem to recall that this is ALWAYS unchecked when Excel
starts. Is that true? If so, then I always have to check the box each time
I start Excel to get around the problem... Can you confirm JE?

Regards,
Ryan--

Signature

RyGuy

> Tools/Options/Calculation, check Iteration.
>
[quoted text clipped - 9 lines]
> > Regards,
> > Ryan--

Reply to this Message