learn microsoft excel

Circular reference in Excel

Home
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
About Us
Free Ebook
Offline Training
Blog
Our Youtube Videos

Circular reference is an irritating problem and when it happens, mostly the user doesn't know what to do. The problem and the solution are simple. You have actually used the reference of the same cell in which you are writing the formula. As shown in the video example, you have written the formula '=b4*c4' and you are writing the formula in C4!
In fact, Excel shows a warning about the circular reference in the status bar also apart from the pop-up window whose message is really not easy to understand. If you click on the 'formulas tab' and then on 'evaluate formula' under 'formula auditing' you can identify and correct the error. Of course, you can correct the error in the formula cell itself by referring to the correct cells.


Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010
About Us Free Ebook Offline Training Blog Our Youtube Videos