Some formulae are generating errors!

Help Home  Previous  Next

Using Exl-Plan > Model-Building Procedure > Avoiding Calculation Errors > Some formulae are generating errors!

This may be due to the use of Cut & Paste or dragging to move assumption values whose cells are referenced in formulae. If possible use Undo to remove the change. Also, review reports for #DIV/0! and #REF!.

If the problem cannot be eliminated, reload an earlier copy of the  model and confirm that it is error-free. Instead of using Cut & Paste, use Copy & Paste and then delete the copied item.

See Also:

Avoiding Calculation Errors

One or more balance sheets are unbalanced!

Opening balance sheet is unbalanced!

The two sub-models are not producing identical results!

Manual Recalculation



Online:  Support   Purchase