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:
One or more balance sheets are unbalanced!
Opening balance sheet is unbalanced!
The two sub-models are not producing identical results!
Online: Support
Free Registration
Purchase Upgrade