If you select "automatic" on the calculation tab of the options page
Excel performs a recalc everytime a value is changed somewhere! If you
select "manual" the sheet is never recalculated until you press F9.

Was that your question?

Hans