I would suggest building your own addin loader. Then you could make it
autorefresh without closing Excel or rebooting, oin a timed basis if
needed.

Look at my Auto-reversioning addin loader for starters, feel free to
re-use the code - the password is dm

http://www.decisionmodels.com/downloads.htm

The Add-In Loader is designed to solve some of the problems of
maintaining and loading Add-Ins on a network:

Dynamic reversioning of add-ins with automatic link
updating.

Control from a central point which add-ins will be
automatically loaded when Excel starts.

Control from a central point which add-ins will be available
for on-demand loading.

Enable updated versions of an add-in to be placed on a
server at the same time as previous versions are in use.

Optionally specify and/or change the network path for each
add-in.

No Registry changes for load and unload.

The Add-In Loader helps the User:

Improve Excel start-up time by bypassing the loading of
add-ins that are only needed intermittently.

Minimize memory use by loading add-ins when needed and
easily unloading them when not needed.

Dynamically load the latest version of an add-in, whilst
unloading any version which is currently loaded.

Dynamically update any links that point to old versions of
loaded add-ins when a workbook is opened or an add-in is loaded.

Charles


So what I want to do is create an auto-update macro. This macro would check
the current version of the installed XLA, and if it is out of date it would
do the following: