Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |