When you want to use an add-in program for Excel, you must
first copy the add-in to a folder on your computer and then load it into Excel.
By default, add-ins (*.xla files) are installed in one of the following
locations:
- The Library folder or one of its subfolders in the
Microsoft Office/Office folder.
- The Documents and Settings/user
name/Application Data/Microsoft/AddIns folder.
You can specify up to eight other custom locations for add-in
programs.
NOTE: If you are using Excel 97, you can specify only up to seven
other custom locations for add-in programs.
Designate Custom Locations for Excel Add-in Programs
To designate custom locations for add-in programs, follow these
steps.
NOTE: This method designates the custom folder only for the current
user. To make an add-in available for all users, you must copy the add-in to
the Library folder or to one of its subfolders in the Microsoft Office/Office
folder.
- Copy the add-in program to the folder that you want to
designate as a custom location for add-in programs.
- Start Excel, and then on the Tools menu,
click Add-Ins.
- Click Browse, locate the add-in, and then
click OK.
- In the Add-Ins available box, click to
select the check box next to the add-in that you want to load, and then click
OK.
Determine the Custom Location of an Add-in After It Is Unloaded
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using Registry
Editor incorrectly. Use Registry Editor at your own risk.
When you unload an add-in that was loaded from a
custom location, Excel remembers the location of the add-in by creating a value
in the following registry key
HKEY_CURRENT_USER\Software\Microsoft\Office\<version>\Excel\Add-in Manager
where <version> is the version of your Excel
program.
NOTE: The value is created when you quit Excel after you unload the
add-in.