I have an Excel file where I have formulas that are conditional. When a
number is calculated there should either be that number or a statement if it
is not in the number range (basically i.e. <0 Not done or =0 Unused)). The
file is on a Govt network server with 20 users. When another user is in the
file and either fills out or adds a new line the resultant is #NAME? Anyone
know what's going on????