Installation
The following are some common issues encountered during the Installation.
1. User Installations are not allowed
The following message gets displayed during Installation:-
"The system administrator has set policies to prevent this installation." (MSI install)
"This installation is forbidden by system policy" (exe installation)
The following message is found in the log: "Machine policy value 'DisableMsi' is 1"
This means that the system administrator has disabled User installations. There are two possible solutions:
- Make the user part of the administrators' group to run the installer as an administrator.
- Do not run as administrator. If the user does not have administrator rights as the Installation will appear successful, but it will install to the administrator user location.
- An administrator makes an administrative installation (see below) then the user installs from this.
2. This Installation is forbidden by system policy. Contact your system administrator.
Check Computer Configuration > Administrative Templates > Windows Components > Windows Installer for a DisableMSI setting. There might not even be a Windows Installer subkey.
Run gpedit and check settings in Computer Configuration->Administrative Templates->Windows Components->Windows Installer
This may work without the reboot
- Click Start -> Control Panel
- Open Administrative Tools
- Open Local Security Settings
- Click Software Restriction Policies
- If no software restrictions are defined, right-click the Software Restriction Policies node and select New Software Restriction Policy
- Double click Enforcement
- Select "All users except local administrators".
- Click OK
- Reboot the machine
3. Installation appears to be successful, but the toolbar does not appear
This is because the add-in did not register. Check the adxregistrator.log (see above). It might indicate that the update to the registry was not successful and which key(s) failed to update. Usually, the problem is permissions. Check the registry HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins
. There should be an entry for the product, e.g. Codis_Excelerator_Sage200_SharedAddin.AddinModule.
This should have entries as shown below - product subkey (e.g. Codis_Excelerator_Sage200_SharedAddin.AddinModule), :
If the entry for the product or the entries is missing, then it will probably be due to permissions on the registry. Sometimes the Add-in registry has special permissions that allow the product entry to be created but does not assign write permissions to the product subkey, so the sub keys and the entries shown above are not created.
This video shows an example of permissions that prevent Excelerator from registering properly and how changing the permissions allows it to register. Remember that the restrictive permissions might result from a deliberate attempt to prevent office Add-ins from being installed. On the other hand, it may result from a group policy, but we've not been able to recreate it yet.
4. Msi Admin extract for restricted Users
An administrative install command extracts an installation image in a folder (typically a shared network folder). Users can then install the software from their profiles by double clicking the MSI created by this command.
-
Run command prompt as administrator
-
Type msiexec /a
Command for Silent/Quite Install with install log: - msiexec /a
Note: The destination Path should not be the same as Source Path.
3. Click on 'Next'.
- Select the folder to extract, and it should be a shared network folder that the users who need to install the software can access.
Click on 'Next'
- Click on 'Finish'.
- The user should double-click on this new MSI to install the software from the network folder.
For example, \\
The Installation should no longer be stopped due to "User installation not being allowed". A UAC prompt may be displayed for administrator credentials, but it would not install to the administrator's profile.
Users may keep or discard/delete the Codis Limited folder created in this shared folder as it is not required.
Please proceed with the licencing process if the Installation is successful.
5. Excelerator Menu bar does not appear
- You may be logged in as a different user from the installation user. If you logged in with your profile, it is still worth following these instructions.
- Click on File Menu in Excel -> click options -> Add-ins -> select COMA dd-ins from the drop down and select go.
6. Manually Registration of COM DLLs
Run a command shell. (Click Start, then Run, enter cmd, and click OK). This will display a window where the user can enter commands.
Change directory to the directory which holds the dll, using the cd command.
cd <directory name><return>
eg. cd c:\Program Files\Codis Excelerator\NL Journal Excelerator <return>
Register the dll file using the regsvr32 command e.g.
regsvr32 nlExcelerator.dll <return>
7. Manage the Add-ins in Excel
Run MS Excel as Administrator
From MS Excel, access the Excel Add-in Manager.
Choose Add-ins – Manage select COM Add-Ins.
If Excelerator appears on the list but is not ticked – Tick the box to enable Codis Excelerator.
If Excelerator does not appear on the list – click Add
Browse and locate the file adxloader.dll (adxloader64.dll for MS Office 64)
For Standard Installation, it would be in either C:\Program Files\Codis Excelerator\Excelerators OR C:\Program Files (x86)\Codis Excelerator\Excelerators
Select adxloader.DLL (adxloader64.DLL for MS Office 64) and add.
8. Error accessing Add-in menu options
If the following error is displayed when accessing a menu option, then follow the instructions below to resolve it.
This may be due to insufficient rights on
"HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\ADXXLForm"
registry node.
Clicking on Details shows the error detail:
Clicking on Show Log outputs the error to Notepad. The log file can be saved locally by selecting Save As and emailed to Codis Support if requested.
Check that the user has sufficient privileges to access the Add-ins by following these steps:
Run Regedit (Start>Run)
Expand HKEY_CURRENT_USER
Software > Microsoft > Office > Excel > AddIns Right click on ADXXLForm
Select Permissions
Ensure Full Control, Read and Special Permissions are ticked
Select Apply and then click OK