#NAME? Error

Problem

#NAME? in labor report from MacNail construction payroll software for Macintosh. 'Code changing' bug in XL4 and later.

Diagnosis

note-- although the code in the accounting 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. So far we have only seen it on Macintosh.

Comments

Entered 1/13/95 by Dennis. Updated 11/22/2010.