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
 Interactive Training

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 Interactive Training