Custom functions address space

[Kevin Thorpe]

I have an Excel addin which contains a list of custom functions. This
addin is placed in a network shared startup directory so all our
workstations load it automatically.

However, some of our workstations don't list the functions properly in
the 'Paste function' dialog box, they prefix the function name with the
workbook and module name. eg.
'Pricetrak Functions.xla'|UserFunctions.ProductDescription()
instead of simply
ProductDescription()

This all used to work before when the addin was on our old Novell
server, but now it's on an NT server it's wrong. Can anyone shed any
light as to why this is happening?

Thanks

 

[Stephen Bullen]

Hi Kevin,

However, some of our workstations don't list the functions properly in
the 'Paste function' dialog box, they prefix the function name with the
workbook and module name. eg.
'Pricetrak Functions.xla'|UserFunctions.ProductDescription()
instead of simply
ProductDescription()

This all used to work before when the addin was on our old Novell
server, but now it's on an NT server it's wrong. Can anyone shed any
light as to why this is happening?

Do the problem workstations also have the addin installed locally?, or
some other conflict with the ProductDescription function?

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie