I'd bet that if excel thinks that there's a circular reference, there's a
circular reference.

But if you have trouble finding the circular reference, maybe Stephen Bullen's
utility will help:

http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

Dean wrote:

I have inherited a file that was set to iterative mode and I turned that off,
then tried to find the circular references, as I do not like iterative
approaches in very complex workbooks, since I feel they can 'solve their way'
through programming errors. In any event, on one of the sheets, the cell that
is identified as circular shows no dependents when I do trace dependents.
Isn't that impossible?

Thanks for any help.
Dean

--

Dave Peterson