UDF does not work on other computers even when appropriate add-in is installed

I have coded and tested an add-in for excel and it works well for my particular application. Using the user defined function in the add-in, I made a template file of sorts that you take and fill in the current data and save as a new name. Several other people in my office were interested in this functionality, so I saved the template and add-in on a network drive that is accessible by everyone in the office. The problem is that even when the add-in is installed on a co-worker's computer if they open a file that I have filled in with data, all of the places that use a UDF from the add-in show #NAME? errors. The document also wants to "update links" and if you follow the link it is trying to access the add-in that is installed on my local machine. The only thing that I can think of that would be a complication is that I am using Office 2007 and some of the other people have Office 2010.
Any ideas?
Thanks!

OK, two files attached. Excel sheet is with sample data, txt file has the add-in module that should perform the desired functions in G3 through G7. Apologies for the text file, couldn't figure out how to get Excel to export the module to anything other than a .bas file on short notice, and didn't think you needed all of the functions in the UDF.
Edit - Stupid me, the problem is with the add-in so I need to attach the add-in not a text file of the code module. I'll re-attach the correct file when I get access tomorrow.

It's a very simple solution:

- you can load your workbook and change the link to your local addin into the add-in on the networkserver: Menubar/edit/link...change link
- save the adapted workbook and put that on the server (or distribute among your colleagues)
- everyone who will download a copy of it will have the correct path to the addin on the server.

Use this macro.
Replace "E:\OF\adressen 002.xls" by the fullname of the addin on the networkserver.

Please Login or Register  to view this content.