Circular Reference when opening program

[RJQMAN]

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.

 

[ozgrid.com]

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

 

[Dave Peterson]

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

 

[RJQMAN]

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

--
Regards








- Show quoted text -

I will give that a try later today. Thanks.

 

[RJQMAN]

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









--

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.