Post the formula and the cell in which it is entered. A Circular
Reference is not necessarily a direct, one-step relationship. A
formula may reference another formula that references another formula,
and so on to quite a depth. The round trip from a formula back to
itself may be quite long and complex, and without careful examination,
a formula may appear not to be circular but in fact really is once you
plumb the depths.

I've never heard of XL2007 having problems with the identification of
circular references.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sun, 16 Nov 2008 10:11:34 -0800, "bmoag"
wrote:

Using the sum function in a blank cell to subtract one cell from another in
a row Excel keeps telling me I am using a circular reference and will not
perform the calculation.
If I move over one cell and enter the same formula all works as it should.
Unbelievable: I think Excel is probably the cause of the stock market
meltdown because this dog can't hunt.