| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
making cells adjust
how do you make cells recalculate when their input cells are changed. eg you
have a cell that is dependent on the value of another. I want this cell to recalculate automatically when i change the value of the input cell. I also want to copy this cell along a row and have all the new cells reaclculate too. Thanks for any help. |
|
#2
|
|||
|
|||
|
Cells with formulas should update automatically as long
as XL is set to calculate automatically. Go to Tools Options Calculation tab and check. HTH Jason Atlanta, GA -----Original Message----- how do you make cells recalculate when their input cells are changed. eg you have a cell that is dependent on the value of another. I want this cell to recalculate automatically when i change the value of the input cell. I also want to copy this cell along a row and have all the new cells reaclculate too. Thanks for any help. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
| Cells losing formatting | Excel Discussion (Misc queries) | |||
Linear Mode
