Freeze cells from further calculation?
 

Is there a way to stop a formula from calculatiing at a given time? I have
a range of cells that I want to be able to click a button to Freeze the
results. I don't want to lose the formulas though.
The best scenario would be a button to freeze and unfreeze (toggle)
calculation of the particular range (or sheet) without affecting the
calculation of other ranges or sheets.
as usual, any help is greatly appreciated.

Jonco

Freeze cells from further calculation?
 

how about copying the values to another cell?


-----Original Message-----
Is there a way to stop a formula from calculatiing at a
given time? I have
a range of cells that I want to be able to click a button
to Freeze the
results. I don't want to lose the formulas though.
The best scenario would be a button to freeze and
unfreeze (toggle)
calculation of the particular range (or sheet) without
affecting the
calculation of other ranges or sheets.
as usual, any help is greatly appreciated.

Jonco


.