Custom Functions in an Add-in

[Rick]

I work in an office using Excel 2007 and we have created a few custom
functions and saved them as an add in within Excel (i.e. with
extension .xla).

The custom functions work fine, but we would like to have them
available to all users on our local network. We currently do this by
having local copies of the .xla file on each machine, however the .xla
file is often updated and it is a pain making sure everyone is running
the most up to date version.

I have tried pointing each users' Excel at a single version of
the .xla file on our server, but this slows Excel down significantly
on loading and seems to lead to crashes. Is there a way to share one
copy of an add in between multiple users over a network?

The server running is SBS 2003 if that helps?

Thanks

 

[JP]

You might want to consider using an installation package that copies
the add-in to the user's XLSTART or Add-Ins folder. You would
distribute that to your end users and they would "install" the new add-
in.

HTH,
JP