One or more balance sheets are unbalanced!

Help Home  Previous  Next

Using Exl-Plan > Model-Building Procedure > Avoiding Calculation Errors > One or more balance sheets are unbalanced!

Refer to Check balance sheet balances at the bottom of Balance Sheets to determine the magnitude and direction of the balance sheet error. Determine whether the value of the error increases each year or remains constant. This can provide a clue to its source. Try to locate the source by progressively removing assumption values and recalculating using the *Tools/Setup > Calculate All & Check menu command or "C" toolbar button.

If the error's source cannot be located or easily fixed, the best option is often to revert to an error-free backup copy of the model.

See Also:

Avoiding Calculation Errors

Opening balance sheet is unbalanced!

Some formulae are generating errors!

The two sub-models are not producing identical results!

Manual Recalculation



Online:  Support   Free Registration   Purchase Upgrade