| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My cell formula results won't update automatically. Help?
I have a cell formula that references other cells in the row. If I change the
value in one of the other cells, the result of my formula does not update unless I click in the formula bar. Is there a setting that updates results automatically? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My cell formula results won't update automatically. Help?
Tools - Options - Calculation tab. Ensure you have calculations set to
Automatic. "Tori" wrote: I have a cell formula that references other cells in the row. If I change the value in one of the other cells, the result of my formula does not update unless I click in the formula bar. Is there a setting that updates results automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why doesnt my formula cell update automatically ? | Excel Discussion (Misc queries) | |||
| how do i automatically replace formula with results | Excel Worksheet Functions | |||
| formuls results won't update automatically (auto is turned on) | Excel Worksheet Functions | |||
| How can a formula in a cell automatically update when inserting a. | Excel Worksheet Functions | |||
| Can I set up the formula to update automatically? | Excel Worksheet Functions | |||
Hybrid Mode
