Excel 2000 Formula Not Working Other Users
 

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????

Excel 2000 Formula Not Working Other Users
 

Sounds like you may be using the Analysis Toolpak, and others are not.
Go to Tools--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

"Arrakeen2000" wrote in message
...
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????