software

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. lt;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????

Sounds like you may be using the Analysis Toolpak, and others are not.
Go to Tools--gt;Addins. Do you have Analysis Toolpak checked? Make sure the
others do, as well.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

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