vert line

Mesa always uses "natural order" recalculation so that the one answer for a given cell is returned correctly even if cell data in other parts of the worksheet are accessed.

By default, Mesa recalculates the entire worksheet each time data in the worksheet is changed. For large worksheets, this could take a second or two.

To disable automatic recalculation, uncheck the "Auto Recalc" check-box in the Sheet Inspector.

If Auto Recalc is disabled, remember to use the Range -> Recalculate Sheet (Apple-=) command to update the worksheet after data has changed.

Circular References

Mesa cannot resolve circular references in cell formulas. Circular Reference debugging is provided to track and allow you to fix circular references.

To enable calculation debugging, select "Stop on Error" or "Stop on Circ." from the pop-up in the Sheet Inspector.

 

Also go to:

Index help

Contents help