I place a formula that calculates something for me in a cell, then I have a
cell on a different worksheet reference that formula cell. The problem is,
onc the calculation has run once, I want the reference cell to keep that
value and never change again, but each time the formula runs, it updates the
reference cell and I cannot stop it.

You can use the technique described here

http://www.mcgimpsey.com/excel/timestamp.html

--


Regards,


Peo Sjoblom

"workingatit" wrote in message
...
I place a formula that calculates something for me in a cell, then I have a
cell on a different worksheet reference that formula cell. The problem is,
onc the calculation has run once, I want the reference cell to keep that
value and never change again, but each time the formula runs, it updates
the
reference cell and I cannot stop it.