Circular Reference

Why Trust Techopedia

What Does Circular Reference Mean?

A circular reference in computer programming is a situation in which two values reference each other. This type of reference can be extremely problematic if two functions or values depend on one another for definition. This term is used in the IT world much like it is in general language to refer to when one thing references another and vice versa.

Advertisements

Techopedia Explains Circular Reference

An example of circular reference in programming is in a Microsoft Excel spreadsheet. Excel involves adding to or operating on various cells with functions that target specific cell ranges. In some cases, two different entries in Microsoft Excel can come to depend on each other for calculation, creating a circular reference. This can create a deadlock situation that makes calculations impossible. To mitigate this kind of situation, Microsoft has included a circular reference feature on the application’s toolbar. This helps users to identify and remove a circular references.

A circular reference is also problematic in programming, and may occur where a function returns a given result that is used by another function to return the same result. In some cases, this will simply provide useless code. In other situations, it may create a deadlock or crash a program.

Advertisements

Related Terms

Margaret Rouse
Technology expert
Margaret Rouse
Technology expert

Margaret is an award-winning writer and educator known for her ability to explain complex technical topics to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles in the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret’s idea of ​​a fun day is to help IT and business professionals to learn to speak each other’s highly specialized languages.