| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with user defined function
Hi,
I have an excel file, which contains user defined functions. On 1 computer it is working, on another not. There I got #VALUE! instead of the calculated result. Both computers are running win2k, with excel 2000. All patches are installed. In excel the analysis toolpak is selected. What can I check more to get this working on the other computer ? Is there also an excel variant of the normal.dot like word ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with user defined function
Is the function in the personal.xls file of one computer and not the other?
"panjo" wrote: Hi, I have an excel file, which contains user defined functions. On 1 computer it is working, on another not. There I got #VALUE! instead of the calculated result. Both computers are running win2k, with excel 2000. All patches are installed. In excel the analysis toolpak is selected. What can I check more to get this working on the other computer ? Is there also an excel variant of the normal.dot like word ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with user defined function
The function is in the excel file himself. On both computers there is no
personal.xls file. "Barb Reinhardt" wrote: Is the function in the personal.xls file of one computer and not the other? "panjo" wrote: Hi, I have an excel file, which contains user defined functions. On 1 computer it is working, on another not. There I got #VALUE! instead of the calculated result. Both computers are running win2k, with excel 2000. All patches are installed. In excel the analysis toolpak is selected. What can I check more to get this working on the other computer ? Is there also an excel variant of the normal.dot like word ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
problem with user defined function
I think you're going to have to check the values in the ranges you pass to the
function or share your code. panjo wrote: The function is in the excel file himself. On both computers there is no personal.xls file. "Barb Reinhardt" wrote: Is the function in the personal.xls file of one computer and not the other? "panjo" wrote: Hi, I have an excel file, which contains user defined functions. On 1 computer it is working, on another not. There I got #VALUE! instead of the calculated result. Both computers are running win2k, with excel 2000. All patches are installed. In excel the analysis toolpak is selected. What can I check more to get this working on the other computer ? Is there also an excel variant of the normal.dot like word ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird recalculation of user defined function | Excel Worksheet Functions | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| user defined function help | Excel Worksheet Functions | |||
| Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
| how to move user defined function | Excel Worksheet Functions | |||
Linear Mode
