Is there anyway of telling Excel to perform a calculation on certain
cells only once.

I have a spreadsheet that performs calculations that include a single
value stored in a cell. I now want to change the value of this cell to
apply to new data being added to the sheet but I don't want to change
the results of past calculations.

Any help would be appreciated.


--
n_davies