Numbers Not Calculating

Problem

Numbers not calculating correctly while using MacNail construction management software. Cells not updating

Diagnosis

• if calc is set to manual in XL options, set it to automatic
• Check the cell which is supposedly not updating. Does it contain a formula? If so, check the formula for typos, error. If it doesn't contain a formula, and it's supposed to, paste it in from somewhere else.
• if this happens in acctg, and the problem is with query/lookups, try Formula\*Query Formulas, etc.

Solution

if the problem is with dimensions formulas in an estimate that was created from a Hyper transfer, see entry #112

Comments

Entered 12/31/92 by Vinay. Updated 11/24/2010.