#NAME? Error

Problem

#NAME? in labor report from MacNail Construction Payroll Software

Diagnosis

'code changing' bug in XL4 and later.
note-- although the code in the manager doesn't change, this also has appeared at least once as a worksheet problem using xl 2.2 with PowerMac.

Solution

temporary worksheet fix-- click in cell C2, make sure it says table.criteria not criteria in formula
manager fix-- open the Accounting Manager, go to C76, make sure both instances say table.criteria not criteria. Also check one instance in C77.
or Replace the manager (see #411)

This seems to be a problem with Excel's handling of the database criteria.

Comments

Entered 1/13/95 by Dennis.