XL: How to Designate Custom Locations for Excel Add-in Programs (810789)

MORE INFORMATION

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.

1. Copy the add-in program to the folder that you want to designate as a custom location for add-in programs.
2. Start Excel, and then on the Tools menu, click Add-Ins.
3. Click Browse, locate the add-in, and then click OK.
4. 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 keywhere <version> is the version of your Excel program.

NOTE: The value is created when you quit Excel after you unload the add-in.