circular reference


Also found in: Dictionary, Acronyms, Wikipedia.

circular reference

[′sər·kyə·lər ′ref·rəns]
(computer science)
A situation created by a programming error in which two or more entities each refer to the other so that the execution of the program is carried on endlessly with no resolution.

circular reference

(1) A programming conflict whereby the operation of each of two routines requires the result from the other routine. See recursion.

(2) In a spreadsheet, a conflict in which the formula computes the cell that the formula itself is located in. For example, a formula in cell A9 that sums the values of "A7 + A8 + A9" is a circular reference.


A Spreadsheet Warning
Circular references are identified in spreadsheets. However, this Excel example does not indicate which cell is the problem.
Mentioned in ?
References in periodicals archive ?
Even the translation guide itself, a glossary of terms in the back of the book, suffers from circular references, density and a presumption of a technical vocabulary not common to most applied music teachers, presumably not his intended audience.
What the Music Said suffers from its reliance on circular references to the discourse of cultural critique where evidence apropos to the music itself might appear.
Circular references are particularly difficult to isolate, since finding them may require examining all possible pathways from the target tree to trees in the last data set that was sorted successfully.
The audit command uses the active worksheet to: report errors, including references to blanks, circular references, and names with bad references; provide a map, which in grid form shows the placement of formulas, numbers, text, logicals, and errors; provide cell path tracing; and provide basic information.