| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Excel cell in formula not refreshing answer cell
When updating cells in Excel the sum cell does not update.
Eg. in cell C1 I will have (=A1+B1) Now if I update a value in cell A1 nothing happens to cell C1, why? I've been using Excel for years and am confused about this. Please advise, any assistance would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update Excel cell in formula not refreshing answer cell
Tools Options Calculation tab select Automatic
"Johnny" wrote: When updating cells in Excel the sum cell does not update. Eg. in cell C1 I will have (=A1+B1) Now if I update a value in cell A1 nothing happens to cell C1, why? I've been using Excel for years and am confused about this. Please advise, any assistance would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update Excel cell in formula not refreshing answer cell
Made the change tested some spreadsheets . . . AWESOME!!!!!! Thank you, much
appreciated. "Teethless mama" wrote: Tools Options Calculation tab select Automatic "Johnny" wrote: When updating cells in Excel the sum cell does not update. Eg. in cell C1 I will have (=A1+B1) Now if I update a value in cell A1 nothing happens to cell C1, why? I've been using Excel for years and am confused about this. Please advise, any assistance would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel show only the answer to a formula in the cell | Excel Discussion (Misc queries) | |||
| count # of instances in cell (a b a) answer 2 formula if possible | Excel Worksheet Functions | |||
| HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL? | Excel Discussion (Misc queries) | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
Linear Mode
