| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you stop a formula from recalculating the second time
If I have a simple formula that gets the cell's value from another cell's
value when the cell is populated, how can I stop the first formula from recalculating ( or getting the new value ) again if the second cell's value changes? This is only a few cells of a few hundred that do similar functions in one workbook. I can't have the workbook do manual calcs. Just these few cells need to stop. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can you stop a formula from recalculating the second time
You can't do this if you want to keep the formulas.
But you could copy|paste special values--or even have an event macro that fires when you change one of those important cells. Shu of AZ wrote: If I have a simple formula that gets the cell's value from another cell's value when the cell is populated, how can I stop the first formula from recalculating ( or getting the new value ) again if the second cell's value changes? This is only a few cells of a few hundred that do similar functions in one workbook. I can't have the workbook do manual calcs. Just these few cells need to stop. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop specific cell from recalculating? | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| Formula not recalculating | Excel Worksheet Functions | |||
| Stop Recalculating? | Excel Discussion (Misc queries) | |||
| Formula for agenda to create start/stop with projected time of ev | Setting up and Configuration of Excel | |||
Linear Mode
