When my program opens, I get a notice that there is a circular
reference. My program automatically goes to a 'welcome sheet' when
opening, and when I cancel the message, the welcome sheet appears, and
I cannot figure out how to find that circular reference. The circular
reference toolbar appears, but there is no cell displayed.

It is a very large program, and seems to work well in general, but
there are a lot of options and a lot of formulas and I do not know how
to find the cell that is causing this error message. I do not know
what page the reference is on, or if it is in a user form, or where to
look.

Every solution I have found recommended requires that I start with a
problem cell. I do not know how to find that problem cell or cells to
start with.

Can anyone tell me how to find this without manually going through
thousands of cells trying to find it? I would really appreciate some
help.

Look at the Status Bar, the cell address will be on there. You MAY need to
switch sheets.



--
Regards
Dave Hawley
www.ozgrid.com
"RJQMAN" <(E-Mail Removed)> wrote in message
news:bffc0df4-5a38-4197-a03f-(E-Mail Removed)...
> When my program opens, I get a notice that there is a circular
> reference. My program automatically goes to a 'welcome sheet' when
> opening, and when I cancel the message, the welcome sheet appears, and
> I cannot figure out how to find that circular reference. The circular
> reference toolbar appears, but there is no cell displayed.
>
> It is a very large program, and seems to work well in general, but
> there are a lot of options and a lot of formulas and I do not know how
> to find the cell that is causing this error message. I do not know
> what page the reference is on, or if it is in a user form, or where to
> look.
>
> Every solution I have found recommended requires that I start with a
> problem cell. I do not know how to find that problem cell or cells to
> start with.
>
> Can anyone tell me how to find this without manually going through
> thousands of cells trying to find it? I would really appreciate some
> help.

You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

RJQMAN wrote:
>
> When my program opens, I get a notice that there is a circular
> reference. My program automatically goes to a 'welcome sheet' when
> opening, and when I cancel the message, the welcome sheet appears, and
> I cannot figure out how to find that circular reference. The circular
> reference toolbar appears, but there is no cell displayed.
>
> It is a very large program, and seems to work well in general, but
> there are a lot of options and a lot of formulas and I do not know how
> to find the cell that is causing this error message. I do not know
> what page the reference is on, or if it is in a user form, or where to
> look.
>
> Every solution I have found recommended requires that I start with a
> problem cell. I do not know how to find that problem cell or cells to
> start with.
>
> Can anyone tell me how to find this without manually going through
> thousands of cells trying to find it? I would really appreciate some
> help.

--

Dave Peterson

On Apr 7, 10:28*pm, "ozgrid.com" <d...@ozgrid.com> wrote:
> Look at the Status Bar, the cell address will be on there. You MAY need to
> switch sheets.
>
> --
> Regards
> Dave Hawleywww.ozgrid.com"RJQMAN" <rjq...@gmail.com> wrote in message
>
> news:bffc0df4-5a38-4197-a03f-(E-Mail Removed)...
>
>
>
> > When my program opens, I get a notice that there is a circular
> > reference. *My program automatically goes to a 'welcome sheet' when
> > opening, and when I cancel the message, the welcome sheet appears, and
> > I cannot figure out how to find that circular reference. The circular
> > reference toolbar appears, but there is no cell displayed.
>
> > It is a very large program, and seems to work well in general, but
> > there are a lot of options and a lot of formulas and I do not know how
> > to find the cell that is causing this error message. *I do not know
> > what page the reference is on, or if it is in a user form, or where to
> > look.
>
> > Every solution I have found recommended requires that I start with a
> > problem cell. *I do not know how to find that problem cell or cells to
> > start with.
>
> > Can anyone tell me how to find this without manually going through
> > thousands of cells trying to find it? *I would really appreciate some
> > help.- Hide quoted text -
>
> - Show quoted text -

I will give that a try later today. Thanks.

On Apr 8, 8:22*am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> You may want to try Stephen Bullen's utility:http://www.oaltd.co.uk/Excel/Default.htm
> Look for FindCirc.zip
>
>
>
>
>
> RJQMAN wrote:
>
> > When my program opens, I get a notice that there is a circular
> > reference. *My program automatically goes to a 'welcome sheet' when
> > opening, and when I cancel the message, the welcome sheet appears, and
> > I cannot figure out how to find that circular reference. The circular
> > reference toolbar appears, but there is no cell displayed.
>
> > *It is a very large program, and seems to work well in general, but
> > there are a lot of options and a lot of formulas and I do not know how
> > to find the cell that is causing this error message. *I do not know
> > what page the reference is on, or if it is in a user form, or where to
> > look.
>
> > Every solution I have found recommended requires that I start with a
> > problem cell. *I do not know how to find that problem cell or cells to
> > start with.
>
> > Can anyone tell me how to find this without manually going through
> > thousands of cells trying to find it? *I would really appreciate some
> > help.
>
> --
>
> Dave Peterson- Hide quoted text -
>
> - Show quoted text -

I have tried that, but it seems to require that I know what cell to
start with.