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:

“HKEY_CURRENT_USER\Software\Microsoft\Office<OfficeVersion>\Excel\Options”

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 different place that every user has access to,
then every user has to set the registry entry in which this path is referenced.

Create a new <<“String / Zeichenfolge”>>

<…path to …\AnalyticsGate-64.xll>

Is the .xll file in the path „C:\Users\%USERNAME%\AppData\Roaming\Microsoft\AddIns“ – then an indication without a path is enough.

/R “AnalyticsGate-64.xll”

If the add-in is on a different path, it must be specified as well (for example, “C:\QlikShare\Add-Ins\”)

/R “C:\QlikShare\Add-Ins\AnalyticsGate-64.xll”

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”

4. Create a new group policy

Important NOTE:

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:

 “AnalyticsGate.xll” or  “AnalyticsGate-64.xll”

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”.