I have a worksheet where some cells use the values of other cells to
calculate their value. What I would like to be able to do is turn this
calculation on and off based on another cell value. I'd like to be able to
have the cell either calculate a new value based on the other cells or freeze
the calculation and keep its old value even when the linked cell values
change. Ideally, the freeze/unfreeze would be controlled by another cell
value. This is basically a reversible and automatic version of what you can
do by pasting the value of a formula into a cell.

Is there any way to do this?

Thanks,
Dave