COM add-in not Present in Excel (Archive KB 1651945)

In Uncategorized by admin0 Comments

COM add-in not Present in Excel

Note: The typical registry path for the COM add-in registry entries is Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Infor Query and Analysis Add-in

Important: If you are using a terminal server or citrix server, please look at the section called Citrix and Terminal Server installs prior to looking at the following solutions.

The 4 Most Common Solutions

1.  Ensure the following Microsoft components are installed

  • Microsoft Primary Interop Assembly (PIA)
  • Microsoft Visual Studio 2010 Tools for Office runtime, if using Office 2010

2.  Users must have Administrator rights to load the add-in including permissions to create the registry entries. Version 10.1.1, and below will require the UAC to be disabled.  This is often the resolution when running Excel.exe as the administrator displays the add-in, but a normal user does not, especially when using Terminal Server or Citrix environments.

The alternative to giving the Terminal Service/Citrix user temporary administrator rights is;

  1. Give the user ‘Full Control’ permissions to their HKEY_USERS key. Example below:HKEY_USERS\S-1-5-21-304862685-1738684395-2000637421-500
  2. Run the ExcelAddinRemoveAdd.exe when connected with the user’s session to the terminal server and ticking the Excel add-in and clicking OK.

Example path of executable:C:\Program Files (x86)\Infor\Query and Analysis\ExcelAddinRemoveAdd.exe

3.  Ensure the old add-in (LsAgXLB.xla) is not present.  If it is, we advise removing as follows:

  • Move the LsAgXLB.xla add-in from the Q&A installation folder to the desktop
  • Remove the Q&A add-in from Excel
  • Move the LsAgXLB.xla add-in file back into the Q&A installation folder
  • Browse to …Infor Query and Analysis>Maintenance>Configure Microsoft Office
  • Tick the Excel option
  • Click OK to successful message

Exit maintenance.

4.  Run the following caspol command:

  • Open a command prompt “Run as administrator”
  • Change directory to: <Windows folder>\Microsoft.Net\Framework\v2.0.50727

Execute the command:

  • caspol –ag 1 –url “file://<Q&A installation folder>\Infor.QAA.Ribbon.dll” FullTrust

Note: Do not copy and paste this command line.

Citrix and Terminal Server Installs

Citrix and Terminal Server Installs usually require the ‘caspol’ command above (point 4) to be run.

As the install/uninstall of XRL is not done via “Add/Remove Programs”, you will need to login to each Terminal or Citrix server as an administrator, and in a command prompt enter “change user /install” to put it into Install Mode.

This should be repeated for any other install whilst in the Install Mode e.g. Microsoft Primary Interop Assembly (PIA), Microsoft Visual Studio 2010 Tools for Office runtime.

Once all installs and/or commands have been run, enter “change user /execute” in the command line to put the server back to Execute Mode. This will allow users to run any applications as normal.

Why is this required? When installing an application on a terminal server it is necessary to change the server to install mode by running “change user /install” from a command prompt or by performing the install through “Add/Remove Programs.” After the installation you must run “change user /execute” to bring it out of install mode. This ensures that the .ini files for the installed application are stored in the TerminalServer system directory. These files are used as the master copies for the user-specific .ini files.

Why is this important? When a user runs an application for the first time, the application looks in the home directory for the .ini files. If it does not find them in the home directory it will look in the Terminal Server system directory and copy them to the user’s home directory. If an application is installed while the server is not in install mode, the .ini files will be saved to the home directory. New users will therefore be unable to access the .ini files from the Terminal Server system directory, and the application will not run.

Other possible solutions

In Excel 2010 32 bit and with Windows 8, somehow the COM add-in was recognised as a file type 98-2003 and it was blocked in Trust Centre Settings. In File Block Settings, remove the tick and removed the add-in via Maintenance. Close Maintenance and add it again via Maintenance, open Excel and the add-in will be visible. In Excel 2013, when Lync 2013 is used, be sure to patch Lync to version 15.0.4569.1503.

5.  Microsoft Visual Studio 2012 OR Microsoft 2013 Lync component has been installed.Un-installing and re-installing ‘Microsoft Visual Studio 2010 Tools for Office runtime’ resolves the issue and allows Visual Studio 2012 to also be used. (Un-installing and re-installing Visual Studio 2012 may also be required)

6.  Ensure only one version of Microsoft Office is loaded on the machine.

7.  If the add-in is marked as Active within Office 2010, but the Infor Q&A tab is not displayed, ensure the ‘Infor Q&A’ option is ticked within File – Options – Customise Ribbon.

8.  The add-in may be disabled. In this case, browse to Excel options – Add-Ins and select Manage ‘Disabled Items’ and click GO. Enable the Infor Query and Analysis ribbon manifest add-in.

9.  The XML file [Excel.exe.config] may be created / generated when installing Office. This XML file “locks” the .NET Framework Version to v1.1.4322 causing the add-in to fail. Renaming the ‘Excel.exe.config’ file can resolve the problem.

10.  Ensure the file path for user registry entries are pointing to the correct location for the Infor.QAA.Ribbon.dll.manifest file.

11.  The Q&A certificate may have expired – ensure the Excel options are not using trusted locations.

12.  Visual Studio Tools for Office (VSTO) 2005 components can become corrupt. Uninstall/re-install VSTO 2005, then re-install Q&A.

Re-installations have been occasionally used as solutions in some environments.

13.  a) Where an installation of Q&A 10.1.0 with Office 2010 (using administrator) does not resolve with the steps above, un-Install Q&A 10.1.0, and installing Q&A 10.1.1 when logged in as the user (still with administrator rights).

      b) Select Custom installation during the re-installation and make sure the option to automatically load the Excel Add-in is enabled.

14.  Uninstalling Office and Q&A before re-installing Office and Q&A in that order can be required to resolve the issue (after all previous steps have been completed).

15.  AppSense can interfere with the Q&A add-in locations, e.g. loading partial profile paths. If using any tool such as AppSense, which includes policy and personalisation management, please test with a non-assisted installation outside of the management software.

16.  In Excel 2010 32 bit and with Windows 8, the COM add-in may be recognised as a file type 98-2003 and blocked in Trust Centre Settings. In File Block Settings, remove the tick and remove the add-in via Maintenance. Close Maintenance and add again via Maintenance, open Excel and the add-in will be visible.

17. In Excel 2013, when Lync 2013 is used, ensure Lync is patched to version 15.0.4569.1503.

18.  Check the GPO (Group Policy) and change the Office 2013 GPO setting to Automation Security Enabled if required. Use application macro security level.

Resolution:
Also see attached video’s.
Affected Products & Releases
Affected Product Affected Release Patch Status Notes
PG – Pegasus XRL Unspecified
Recommended Articles for Products :
Recommended Articles for Releases :
Keywords : COM add-in; add-in not present in Excel;not present in Excel; add-in ;add in; Com Add in; XRL addin: XRL Add-in
Type : Knowledge
Classification :
Severity : 3 – Medium
Status : Complete
KB Owner : Tony Cyprys
Last Updated : 08 Jan 2016
Platform : Windows
Platform OS : Windows
Created: 09 Sep 2015 05:11 PM SAST
Revised: 08 Jan 2016 11:50 AM SAST

Leave a Comment