To suppress formula evaluation, click the red triangle menu next to the keypad and select Suppress Eval. When evaluation is suppressed, the formula icon appears dimmed.
•

•

You can turn off formula evaluation for all formulas by selecting Suppress Formula Eval from the data table red triangle menu. To reevaluate formulas, select Rerun Formulas from the data table red triangle menu. You can also click the Apply button in the Formula Editor for each column that contains a pending formula.

•

When you turn off formula evaluation, edit a formula, and click Apply, you are prompted for whether to evaluate the formula. To allow formula evaluation once, click Evaluate formula this time.
