View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary
 
Posts: n/a
Default Simple Circular Reference Problem

This is the first time i am trying to play around with circular reference.
What I am trying to do is.....

I am entering a formula in cell A1, The formula is =A1+B1 (very simple)

I have already checked the Iteration box and set the maximum iterations to
1. (tools/options/calculation)

the formula is working but.....whenever i save it or do anythingin in the
sheet..like..delete something, enter a figure in some other cell etc. etc.,
it adds the last value again.

for example - I enter 2 in B1, A1 shows 2, then I enter 3 in B1, A1 shows 5.
Now, if do anything in the sheet it will add 3 again and A1 would show
8...if I keep on pressing CTRL+S, it keeps on adding 3 to A1.

Can anyone give me the solution to this problem please?

Thanks
Gary