How is it even remotely possible to create (intentionally) a reference that's (inadvertently) circular? How could you possibly fail to realize this would happen, unless you were stabbing formulas in the dark?
Quite often I create inadvertent circular references always by inadvertently typing the wrong thing, say C2 when I honestly meant B2. The Excel UI for "yes, I know I meant B2 not C2" is subpar.
Posted by Matt Bruce at May 15, 2008 02:53 PMI've done it before. It just involves enough layers so that you forget that the last layer depends on the first one.
Posted by: Paul at May 16, 2008 01:43 PM