Circular reference

[april]

Hi

I have a spreadsheet consisting of approximately 8 worksheets. When I open
the document, I am notified of a circular reference but how do I find it? I
have tried using the Toolbar but get the following message "The Trace
Dependents command found no formulates that refer to the active cell".

Please can you let me know how to find the circular reference?

Thanks inavance.

 

[Dave Peterson]

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

 

[april]

Perfect! It's worked, thank you.

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

 

[Dave Peterson]

You're welcome from me and I be Stephen is happy that you found his program
useful.