Installation Steps Server rollout
1. Check: Access to the add-in
To set up the add-in, the user must have access to the add-in (xll file). Fore Example: \\yourserver\addins\
2. Check: Registry settings
Furthermore, a registry entry must be set in “HKEY_CURRENT_USER”.
The following key contains the path to the add-in:
There is or can be one or more “OPEN” keys OPENx= / R “<path_to_.xll>”
See example: “OPENx” in the above key may have one or more “OPEN” key values.
One for each add-in. The following count applies:
e.g.: OPEN = Path to add-in 1 OPEN1 = Path to add-in 2 OPEN2 = Path to add-in 3 you can put the add-in in a diffrent place that every user has access to,
then every user has to set the registry entry in which this path is referenced.
Is the .xll file in the path „C:\Users\%USERNAME%\AppData\Roaming\Microsoft\AddIns“ – then an indication without a path is enough.
If the add-in is on a different path, it must be specified as well (for example, C:\AddIn)
3. Check: Officeversions
- Office 2003 -> 15.0 “HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options”
- Office 2016 and newer -> 16.0 “HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options”
If no add-in is registered yet, the value (string) “OPEN” must be created. If one or more add-ins already exist, a value (string) “OPEN1 … etc. OPENx” must be created. Where x is the next number to use (for example, “OPEN4“ if Sense Excel is the 4th add-in)
Update a version:
Our add-in carries the version number in its name. This can be unfavorable for you, if you want to provide the users with a new version, you always have to adjust the registry.
Therefore, the version number part of the file name and the registry entry can be removed, ie without a version number: for example:
This has the consequence that the registry entry only needs to be set once, and to update the add-ins only the xll must be overwritten. Via “Copy and Paste”.