Have you ever created a calculation within Microsoft Excel, possibly worked very hard on it, then when you pressed enter a message popped up about a circular reference? This message means that your calculation will not work, and depending on what button you press you might get another toolbar and lovey marks on the sheet.
What has happened is that you have accidentally used the cell that the calculation is in as a reference within the calculation. Makes sense? Let me show you.
You click into cell C1 and start typing a calculation:
= A + B1
But you do not stop there, the cell you are in is still C1 but you add:
= A1 + B1 + C1
Your calculation is in C1, so if it adds something and puts that in C1 that is now the value of C1 and it has to add all over again, the new total is in cell C1 and has to be added again, and so on and so on until Excel explodes! Just kidding, that is why a circular reference is created because it recognises that there this specific type of error and stops calculating.
Katherine