Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular ref
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular ref
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Circular ref
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$11 7,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$11 7,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 "JLGWhiz" wrote: 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular or semi-circular chart | Charts and Charting in Excel | |||
Circular | Excel Worksheet Functions | |||
Need help with Circular (?) | Excel Worksheet Functions | |||
Circular? | Excel Programming | |||
Circular:G4? | Excel Worksheet Functions |