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.

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

april wrote:

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

Perfect! It's worked, thank you.

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

april wrote:

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're welcome from me and I be Stephen is happy that you found his program
useful.

april wrote:

Perfect! It's worked, thank you.

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

april wrote:

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

--

Dave Peterson