| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send to from excel 2003 after upgrade from Office 2000 | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
| Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Linear Mode
