Questions

Answer for:

Circular Reference Warning

Message 2 of 8

View entire thread
+
0 Votes

A circular reference is created if you enter a formula into a cell that links directly or indirectly to itself.

A circular reference is just a formula that depends on its own value.

There should not be any circular references in your workbooks unless you specifically want them to be there.

If you receive a circular reference warning when you are not expecting one it means that the formula has been entered incorrectly.

These can be created very easily (often by mistake). Just link cell B2 to cell B3 and then link cell B3 to cell B2.

More on the subject here:
http://www.bettersolutions.com/excel/EUZ139/VC827516332.htm

Please post back if you have any more problems or questions.
If this information is useful, please mark as helpful. Thanks.