Can you limit the amount of times a calc is performed on certain cells
 

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

n_davies:

It appears to me you wish to track scenarios. You can learn more about
scenarios using Microsoft's help function.

Personally, scenarios are not as friendly when sending to a supervisor. In
the world in which I live, we use separate tabs. To the extent separate tabs
or separate files are the not feasible for you - try the scenario approach.
It is slick.

Cheers.

"n_davies" wrote:


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