Circular ref

[David]

Hi Group,

This may not be related to the code in the file, but I am being told that I
have a circular ref and Excel indicates the cell.

Even if I delete the contents of the cell, it is still indicated as a
circular ref.

Anybody else experience this?

Thanks,
David

 

[JLGWhiz]

It means you have formulas that make two or more cells interdependent upon
each other and Excel cannot resolve the conflict. e.f. Cell D1: =a1+b1

Cell D2: =a1 + d1 creates a circular reference to cell D1 because cell d1

also depends on cell a1
for its solution. Excel does not know how to resolve the interdependency.
Nor do I.

 

[David]

Hi,

Like I said, it indicates the cell ref, but even if the contents of the cell
are deleted the message continues. If I trace both dependants and precedents
it finds nothing, especially if the contents are deleted.

I am starting to wonder if something has been corrupted. I now have another
problem.

An array formula
{=SUM(IF($A$29:$A$112=$D$123,IF($D$29:$D$112=$D$117,G29:G112,0),0))} works
well in one cell, but when I copy it over one cell to the right it fails,

(=SUM(IF($A$29:$A$112=$D$123,IF($D$29:$D$112=$D$117,H29:H112,0),0)))

The only difference is the column that is summed - compare
G29:G112 to H29:H112
Initially I get the same result as is in the cell copied from, then after
F2, Ctrl+Shift+Enter it goes to zero. There is data in Column H. I am hoping
I do not need to reload Excel. Seems to work fine when applied to column G
and the result is as expected.

Thanks,
David