Ok, I must have hit an option I did not know of.... ??

I have a simple sum function on my spreadsheet. (=sum(B1:B10)
However, after setting the intial sum, when I change the contents of the row
source, the formula does not automatically update?? I do not recall this
workiong like this.
Example, in b1 through b10 the value is 1 so the =sum function cell would =
10.
now I change b1 to = 2 the sum shoudl automatically = 11 right? No it does
not, the value still shows 10 until I manually drag through the cells again
to refresh it? Please tell me there is a fix for this somewhere???


janell