I am trying to make a stock control work sheet and I am having problems with a circular reference.
Take cell B2 and place this formula in it =(A2+B2). I now have a circular reference.
I have turned on the iteration in Tools,Options calculation and limited the maximum iterations to 1.
My problem is once the formula has been dragged down to B12 and i start to fill in the worksheet
with data starting at A2 down to A12. all the data that has been calculated above is automatically altered. In fact you can place data any where on the sheet and the data in the circular reference cells will change. This also applies to excel 2010.
Please try this yourselves and hopefully you will come up with an answer. If not I will start to learn VBA in excel.