User Defined Functions in an Add-in

[ElvisSteel]

I have setup an add-in containing several of my commonly used User Defined Functions. When I use one of these functions in a workbook with the add-in loaded, I just get #NAME? unless I specify the Add-in name explicitly prior to the function,
e.g. =Addin.xla!FunctionName(params...)

When I press enter, this works OK, but the in-cell formula shows...
=FunctionName(params...), the Addin bit has disappeared.
If I re-edit this cell, F2+Enter, the #NAME? error reappears.

Can anyone advise what I am doing wrong?
I am using Excel 2003 with Windows XP.

Thanks

 

[tusharm]

Speculation: Does the name conflict with an Excel function/some other type of reserved name?

 

[ElvisSteel]

I don't think so, I originally called it CPFunction.xla, and then tried CPF.xla

 

[tusharm]

No, the name of the function, not the addin.

 

[ElvisSteel]

Hi and thanks for your help on this, the functions were called "CalcRtn", "CalcFormula" and "CalcRating" - I am fairly sure that not all of these can be reserved names!
Anyway, I renamed the functions in the add-in (to CalcReturn, CalcScore and CalcRate) and then changed the formulae in the worksheet and it worked straight away. The only thing I can think is that the problem was caused because I originally cut the functions out of the worksheet macro, and pasted them into the add-in without changing the worksheet formulae. Maybe the worksheet couldn't resolve this.
All seems OK now, and I have since added a few more and each time created the function before entering the formula into the worksheet and all is OK.
Thanks again for taking the time to help

 

[tusharm]

You are welcome. Glad it all worked out.