Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All topics
Print

Terminal Server Installation

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

War dieser Artikel hilfreich?
0 out Of 5 Stars
5 Sterne 0%
4 Sterne 0%
3 Sterne 0%
2 Sterne 0%
1 Sterne 0%
Wie können wir diesen Artikel verbessern?
Please submit the reason for your vote so that we can improve the article.
Zurück Security Rules for Qlik Sense
Weiter How to create the restricted version of AnalyticsGate Excel Add-In!
Index