Circular Reference when opening program
 

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.

Circular Reference when opening program
 

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" wrote in message
...
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.

Circular Reference when opening program
 

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

Circular Reference when opening program
 

On Apr 7, 10:28*pm, "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" wrote in message

...



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.

Circular Reference when opening program
 

On Apr 8, 8:22*am, Dave Peterson 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.