Cell formulas are not recomputing
 

I just created a spreadsheet with some simple formulas, i.e. A4+B7 and when I
first create it the answer is correct. When I change the value in A4 or B7 I
expect my formula cell to recompute and it doesn't??? I did not change any
setups. Anyone have any idea what might have caused this. I checked my
other spreadsheets and it is a global problem. Thanks, Pauline

Cell formulas are not recomputing
 

Tools | Options | Calculation Tab | 'check' Automatic


"Pauline" wrote in message
...
I just created a spreadsheet with some simple formulas, i.e. A4+B7 and when
I
first create it the answer is correct. When I change the value in A4 or
B7 I
expect my formula cell to recompute and it doesn't??? I did not change
any
setups. Anyone have any idea what might have caused this. I checked my
other spreadsheets and it is a global problem. Thanks, Pauline

Cell formulas are not recomputing
 

Thank you. That fixed the problem. Have a great day!

"Gaurav" wrote:

Tools | Options | Calculation Tab | 'check' Automatic


"Pauline" wrote in message
...
I just created a spreadsheet with some simple formulas, i.e. A4+B7 and when
I
first create it the answer is correct. When I change the value in A4 or
B7 I
expect my formula cell to recompute and it doesn't??? I did not change
any
setups. Anyone have any idea what might have caused this. I checked my
other spreadsheets and it is a global problem. Thanks, Pauline