COM add-in not present in Excel
Posted by Syed Qutubuddin, Last modified by Kaize, Ahamed on 06 August 2019 03:47 PM
COM add-in not present in Excel
Most common solutions
1) Ensure the following Microsoft components are installed
- Microsoft Primary Interop Assembly (PIA)
2) Users must have Administrator rights to load the add-in including permissions to create the registry entries. Up until version 10.1.1, you will also need to disable UAC. This is often the resolution when running Excel.exe as administrator displays the add-in, but not for a normal user, especially on Terminal Server or Citrix environments.
a) Temporarily give the user Administrator privileges, load the add-in via maintenance and remove admin rights.
The alternative to giving the Terminal Service/Citrix user temporary administrator rights is
i) Give the user 'Full Control' permissions to their HKEY_USERS key. Example below:
ii) 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:
3) Ensure the old add-in (LsAgXLB.xla) is not present. If it is, remove with the following steps:
- Move the LsAgXLB.xla add-in from the Q&A installation folder to the desktop
- Open a command prompt “Run as administrator”
5) Microsoft Visual Studio 2012 OR Microsoft 2013 Lync component has been installed.
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 -> Customize Ribbon.
8) The add-in may be disabled. If so, 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) Sometimes an xm file [Excel.exe.config] is 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' 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) One installation of Q&A 10.1.0 with Office 2010 done as administrator could not be resolved with the steps above. Un-Installing Q&A 10.1.0 and Installing Q&A 10.1.1 when logged in as the user (still with administrator rights) resolved the issue.
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 personalization management, please test with a non-assisted installation outside of the management software.
16) In Excel 2010, 32 bits and with Windows 8, somehow the COM add -in was recognized as a file type 98-2003 and it was blocked in Trust Center Settings, in File Block Settings. I unticked it from there, and removed the add in via Maintenance, closed it and added it again via Maintenance, opened excel and the add in was visible
17) In Excel 2013, where Lync 2013 is used, be sure to patch Lync to version 15.0.4569.1503 .
18) Check the GPO ( Group Policy ) , change the Office 2013 GPO setting to Automation Security Enabled , Use application macro security level.
19) Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Infor Query and Analysis Add-in : make sure load behavior is set to 3