L
L-E Eriksson
Hello!
I have a excel add-in with a few User Defined Functions.
The add-in is used by ten different users.
I have placed the add-in in the XLStart folder on each client machine
(C:\Program Files\Microsoft Office\OFFICE11\XLSTART).
My UDF looks like this in the formula field:
=GetCustomerName(A4)
When saving a workbook from one computer onto a network drive and then
opening the same workbook on a different computer, I have problems. When
opening the workbook on the other computer, the UDF looks like this:
='C:\Program Files\Microsoft
Office\OFFICE11\XLSTART\MyXLA.xla'!GetCustomerName(A4)
So the path of the xla is saved in the formula field. That would be OK if
the UDF could resolve the formula. But I get an error:
#NAME
in every cell where I have the UDF.
If I remove the path of the .xla the function can be resolved, but the error
returns if the workbook is saved and then opened on another computer.
I think I am doing something fundamentally wrong here, please enlighten
me...
Regards
L-E Eriksson
I have a excel add-in with a few User Defined Functions.
The add-in is used by ten different users.
I have placed the add-in in the XLStart folder on each client machine
(C:\Program Files\Microsoft Office\OFFICE11\XLSTART).
My UDF looks like this in the formula field:
=GetCustomerName(A4)
When saving a workbook from one computer onto a network drive and then
opening the same workbook on a different computer, I have problems. When
opening the workbook on the other computer, the UDF looks like this:
='C:\Program Files\Microsoft
Office\OFFICE11\XLSTART\MyXLA.xla'!GetCustomerName(A4)
So the path of the xla is saved in the formula field. That would be OK if
the UDF could resolve the formula. But I get an error:
#NAME
in every cell where I have the UDF.
If I remove the path of the .xla the function can be resolved, but the error
returns if the workbook is saved and then opened on another computer.
I think I am doing something fundamentally wrong here, please enlighten
me...
Regards
L-E Eriksson