I have created a UDF and an Excel Add-in which contains this function. I want to call this function on a spreadsheet that can be viewed by anyone in my group on our network. The problem is that even if others have the add-in installed, Excel changes the function call so that it includes the full path name of the Excel Add-in. This means that Excel now looks for the add-in and function on my computer instead of looking at the add-ins installed on the other computer.
For example I want to call a function called rkdays()
If I write in cell C4 “=rkdays(…)” the function works fine. When I save it and someone else opens it they see in cell C4
“‘C:\Documents and Setting\….\rk.xla’!rkdays(…)”
The path above is for my computer however and so it is simply not found. If you delete the path the function works just fine. I would like Excel not to write that path in the first place.