Can User-defined functions be written so that they will work on every computer on a network?

My situation:

I wrote a function called "Address1" that returns the street address for a customer. (Of course, I have Address2 and so forth...my application prints checks.) We don't have a server, so common files are stored in a "Common Area" folder on one of the computers with peer-to-peer file sharing. The Address1 function is in an xla file in the "Common Area" folder. Excel on every computer is setup to load the xla.

Here's what happens:

Any user can enter the function in a cell ("=Address1("customer")) and it works fine. HOWEVER, if the file is saved and reopend by a different computer on the network, the path to the function is inserted in the cell ("=/path info/Common Area/Address1("customer")) and the function does not work.

Is there a solution short of writing an automation add-in?

Thanks,
Fred

Sounds like the add-in isn't getting loaded properly or the path to the xla is differently mapped on different machines. This will cause Excel to complete the formula with the last known 'good' path.

For machines that are to use the add-in click tools > add-in and select the appropriate add-in. For custom ones you'll probably need to 'browse' for the file.

Machines that open the file showing the full path will need to exit it without saving or the path will be in every instance.

Hope this helps.