Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert UDF from excel 2000 to excel 2003
Hello,
I have a spreadsheet with 2 UDF's. It works fine in excel 2000, but not in 2003. The UDF is in the form udfname(a;b;c;d;e). When I use udfname(1;2;3;4;5) it works, but when I use udfname(a1;a2;a3;a4;a5) it doesn't work, even not when I fill in 1 in cel a1, 2 in cel a2 etc. I didn't create the sheet by myself, maybe it was created in excel 97. Does anyone have an idea how to solve this ? Is it possible to edit the UDF ? I cannot fnd it as a macro or in the viasula basic editor. Regards, Panjo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert UDF from excel 2000 to excel 2003
< it doesn't work,
How do you notice that? What does "doesn't work" mean? Blank cell? Error message (What)? Wrong answer? What are the UDFs supposed to do? Are they not Analysis Toolpak functions? Toolsadd-ins, check Analysis Toolpak and try again. -- Kind regards, Niek Otten - Kind regards, Niek Otten "panjo" wrote in message ... | Hello, | | I have a spreadsheet with 2 UDF's. It works fine in excel 2000, but not in | 2003. | The UDF is in the form udfname(a;b;c;d;e). | When I use udfname(1;2;3;4;5) it works, but when I use | udfname(a1;a2;a3;a4;a5) it doesn't work, even not when I fill in 1 in cel a1, | 2 in cel a2 etc. | | I didn't create the sheet by myself, maybe it was created in excel 97. | | | Does anyone have an idea how to solve this ? | Is it possible to edit the UDF ? I cannot fnd it as a macro or in the | viasula basic editor. | | Regards, | Panjo | | | | | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert UDF from excel 2000 to excel 2003
Yes, you are right. After checking the analysis toolpak functions and
recalculating the sheet it is working. (first I got #VALUE! in each field). Thanks a lot. Panjo "Niek Otten" wrote: < it doesn't work, How do you notice that? What does "doesn't work" mean? Blank cell? Error message (What)? Wrong answer? What are the UDFs supposed to do? Are they not Analysis Toolpak functions? Toolsadd-ins, check Analysis Toolpak and try again. -- Kind regards, Niek Otten - Kind regards, Niek Otten "panjo" wrote in message ... | Hello, | | I have a spreadsheet with 2 UDF's. It works fine in excel 2000, but not in | 2003. | The UDF is in the form udfname(a;b;c;d;e). | When I use udfname(1;2;3;4;5) it works, but when I use | udfname(a1;a2;a3;a4;a5) it doesn't work, even not when I fill in 1 in cel a1, | 2 in cel a2 etc. | | I didn't create the sheet by myself, maybe it was created in excel 97. | | | Does anyone have an idea how to solve this ? | Is it possible to edit the UDF ? I cannot fnd it as a macro or in the | viasula basic editor. | | Regards, | Panjo | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions | |||
xla created in Excel 2003 won't run in Excel 2000 | Excel Discussion (Misc queries) | |||
Convert excel 2003 (in xml format) to excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) |