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: