Microsoft KB Archive/810789

= XL: How to Designate Custom Locations for Excel Add-in Programs =

Article ID: 810789

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SUMMARY
This article describes how to designate custom locations for Excel add-in programs.



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/ /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 key

 

where is the version of your Excel program.

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

Keywords: KB810789

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.