XLL addin not showing in Excel

Add-in Express™ Support Service
That's what is more important than anything else

XLL addin not showing in Excel
 
Mark Meyer




Posts: 34
Joined: 2014-03-26
Hello,

We're having an issue with one client's computer where the XLL addin is not showing in Excel. The COM addin shows and loads fine but none of our custom functions (XLL) will appear. We've reviewed all the different suggestions on this site and nothing seems to do the trick. It's not showing in the Excel -> Options -> Addins screen at all (normal spot or disabled)

They are running Excel 2016 MSO (16.0.9029.2106) 32 bit - Home and Business 2016.
Version 1802 (Build 9029.2167 Microsoft Store)

ADXLoader
Add-in Express Loader Log File: 03/06/2018 14:38:16:401

Startup directory: C:\Users\SallyS\AppData\Local\miExcel\
Loader version: 8.7.4430.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Excel_16010.9029.2167.0_x86__8wekyb3d8bbwe\Office16\EXCEL.exe"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
14:38:16:407 3164 0208 Start.
14:38:16:407 3164 0208 Creating a new instance of the add-in loader.
14:38:16:408 3164 0208 Loading mscoree.dll
14:38:16:408 3164 0208 Success.
14:38:16:408 3164 0208 Loading the configuration from the system registry.
14:38:16:408 3164 0208 Getting the latest CLR version.
14:38:16:409 3164 0208 The latest CLR version is 'v4.0.30319'.
14:38:16:409 3164 0208 The configuration has been loaded successfully.
14:38:16:409 3164 0208 Runtime version: v4.0.30319.
14:38:16:409 3164 0208 Assembly name: miExcel, PublicKeyToken=8997CDA2B0DAD049.
14:38:16:409 3164 0208 Class name: miExcel.AddinModule.
14:38:16:409 3164 0208 Registry key: CLSID\{3134F228-9C9C-4F2A-AE6F-F029AEF8498B}.
14:38:16:409 3164 0208 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
14:38:16:409 3164 0208 Loading CLR: v4.0.30319.
14:38:16:409 3164 0208 Calling CLRCreateInstance method.
14:38:16:409 3164 0208 Success.
14:38:16:409 3164 0208 Calling GetRuntime method.
14:38:16:409 3164 0208 Success.
14:38:16:409 3164 0208 Checking if the hosting API of .NET Framework v4.0 beta is installed.
14:38:16:416 3164 0208 The hosting API is up to date.
14:38:16:416 3164 0208 Calling SetDefaultStartupFlags method.
14:38:16:416 3164 0208 Success.
14:38:16:416 3164 0208 Calling GetInterface method for the CorRuntimeHost interface.
14:38:16:416 3164 0208 Success.
14:38:16:416 3164 0208 Starting CLR...
14:38:16:416 3164 0208 Success.
14:38:16:416 3164 0208 Getting the CLR version.
14:38:16:416 3164 0208 The CLR v4.0.30319 has been initialized successfully.
14:38:16:416 3164 0208 Creating a new domain setup.
14:38:16:417 3164 0208 Success.
14:38:16:417 3164 0208 Getting the add-in directory.
14:38:16:417 3164 0208 Success. The directory is 'C:\Users\SallyS\AppData\Local\miExcel\'
14:38:16:419 3164 0208 The 'shadow copy' is disabled.
14:38:16:419 3164 0208 Creating a new application domain.
14:38:16:425 3164 0208 Success.
14:38:16:425 3164 0208 Creating an instance of the managed class. Assembly identity: 'miExcel, PublicKeyToken=8997CDA2B0DAD049'
14:38:17:050 3164 0208 Success.
14:38:17:050 3164 0208 Unwrapping the managed class.
14:38:17:272 3164 0208 Success.
14:38:17:273 3164 0208 Querying the add-in extensibility.
14:38:17:274 3164 0208 Success.
14:38:17:274 3164 0208 Querying the custom task panes.
14:38:17:274 3164 0208 Success.
14:38:17:274 3164 0208 Querying the ribbon extensibility.
14:38:17:274 3164 0208 Success.
14:38:17:274 3164 0208 Querying the form regions.
14:38:17:274 3164 0208 Success.
14:38:17:274 3164 0208 Querying the encryption provider.
14:38:17:274 3164 0208 The 'EncryptionProvider' interface is not supported.
14:38:17:274 3164 0208 Getting the dispid of the 'Dispose' method.
14:38:17:277 3164 0208 Success.
14:38:17:277 3164 0208 The instance of the managed add-in class has been created successfully.


ADXRegistrator
Add-in Express Registrator Log File: 03/06/2018 14:48:16

Installation directory: C:\Windows\Installer\
Registrator version: 8.7.4430.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Windows\Installer\MSI2AA0.tmp" /install="C:\Users\SallyS\AppData\Local\miExcel\miExcel.dll" /privileges=user /returnExitCode=false
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
--------------------------------------------------------------
14:48:16 0560 Starting the add-in registration process.
14:48:16 0560 Loading mscoree.dll
14:48:16 0560 Success.
14:48:16 0560 .NET Framework installation directory:
14:48:16 0560 The latest version of .NET Framework: 'v4.0.30319'
14:48:16 0560 Loading CLR: v4.0.30319.
14:48:16 0560 Calling CLRCreateInstance method.
14:48:16 0560 Success.
14:48:16 0560 Calling GetRuntime method.
14:48:16 0560 Success.
14:48:16 0560 Checking if the hosting API of .NET Framework v4.0 beta is installed.
14:48:16 0560 The hosting API is up to date.
14:48:16 0560 Calling GetInterface method for the CorRuntimeHost interface.
14:48:16 0560 Success.
14:48:16 0560 Starting CLR...
14:48:16 0560 Success.
14:48:16 0560 Getting the CLR version.
14:48:16 0560 The CLR v4.0.30319 has been initialized successfully.
14:48:16 0560 Creating a new domain setup.
14:48:16 0560 Success.
14:48:16 0560 The 'shadow copy' is disabled.
14:48:16 0560 Creating a new application domain.
14:48:16 0560 Success.
14:48:16 0560 Getting the base directory for the domain.
14:48:16 0560 Success. The directory is 'C:\Users\SallyS\AppData\Local\miExcel\'.
14:48:16 0560 Searching for the Add-in Express core library.
14:48:16 0560 Success. The 'AddinExpress.MSO.2005.dll' file is found.
14:48:16 0560 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
14:48:16 0560 Assembly identity is 'AddinExpress.MSO.2005'.
14:48:16 0560 Success.
14:48:16 0560 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
14:48:16 0560 Success.
14:48:16 0560 Calling the managed registration procedure (DISPID = 1610743823).
14:48:18 1124 32 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\miExcel.AddinModule' registry key was created successfully for the 'miExcel.AddinModule' class: LoadBehavior=3
14:48:18 1124 32 bits. The 'HKCU\CLSID\{3134f228-9c9c-4f2a-ae6f-f029aef8498b}\InprocServer32' registry key was created successfully for the 'miExcel.AddinModule' class: C:\Users\SallyS\AppData\Local\miExcel\adxloader.miExcel.dll
14:48:18 1124 64 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\miExcel.AddinModule' registry key was created successfully for the 'miExcel.AddinModule' class: LoadBehavior=3
14:48:18 1124 64 bits. The 'HKCU\CLSID\{3134f228-9c9c-4f2a-ae6f-f029aef8498b}\InprocServer32' registry key was created successfully for the 'miExcel.AddinModule' class: C:\Users\SallyS\AppData\Local\miExcel\adxloader64.miExcel.dll
14:48:18 1124 32 bits. The 'HKCU\CLSID\{907d0e21-466c-3e37-8f59-f5bf485a23a0}\InprocServer32' registry key was created successfully for the 'miExcel.XLLModule' class: mscoree.dll
14:48:18 1124 64 bits. The 'HKCU\CLSID\{907d0e21-466c-3e37-8f59-f5bf485a23a0}\InprocServer32' registry key was created successfully for the 'miExcel.XLLModule' class: mscoree.dll
14:48:19 0560 Registration success.
14:48:19 0560 The add-in registration process is completed with HRESULT = 0.
Posted 06 Mar, 2018 16:17:15 Top
Andrei Smolin


Add-in Express team


Posts: 18857
Joined: 2006-05-11
Hello Mark,

We've reproduced the issue. Now we look into it.


Andrei Smolin
Add-in Express Team Leader
Posted 07 Mar, 2018 03:54:38 Top
Mark Meyer




Posts: 34
Joined: 2014-03-26
Hey Andrei,

Any update on this?
Posted 21 Mar, 2018 16:41:58 Top
Andrei Smolin


Add-in Express team


Posts: 18857
Joined: 2006-05-11
Hello Mark,

We are going to publish 8.8 today. This issue is fixed in this build.


Andrei Smolin
Add-in Express Team Leader
Posted 22 Mar, 2018 02:09:21 Top
Mark Meyer




Posts: 34
Joined: 2014-03-26
Awesome. Thanks!
Posted 22 Mar, 2018 07:23:37 Top
Andrei Smolin


Add-in Express team


Posts: 18857
Joined: 2006-05-11
Mark,

We've published 8.8.4450. Please see https://www.add-in-express.com/downloads/adxnet.php.


Andrei Smolin
Add-in Express Team Leader
Posted 22 Mar, 2018 08:20:20 Top
Mark Meyer




Posts: 34
Joined: 2014-03-26
Hi Andrei,

I tested this on my clients computer and the XLL addin still isn't showing up. I don't have a copy of this Microsoft Store version of Excel to test on myself.

Registrator

Add-in Express Registrator Log File: 03/22/2018 08:52:04

Installation directory: C:\Windows\Installer\
Registrator version: 8.8.4450.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Windows\Installer\MSI2115.tmp" /install="C:\Users\SallyS\AppData\Local\miExcel\miExcel.dll" /privileges=user /returnExitCode=false
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
--------------------------------------------------------------
08:52:04 0536 Starting the add-in registration process.
08:52:04 0536 Loading mscoree.dll
08:52:04 0536 Success.
08:52:04 0536 .NET Framework installation directory:
08:52:04 0536 The latest version of .NET Framework: 'v4.0.30319'
08:52:04 0536 Loading CLR: v4.0.30319.
08:52:04 0536 Calling CLRCreateInstance method.
08:52:04 0536 Success.
08:52:04 0536 Calling GetRuntime method.
08:52:04 0536 Success.
08:52:04 0536 Checking if the hosting API of .NET Framework v4.0 beta is installed.
08:52:04 0536 The hosting API is up to date.
08:52:04 0536 Calling GetInterface method for the CorRuntimeHost interface.
08:52:04 0536 Success.
08:52:04 0536 Starting CLR...
08:52:04 0536 Success.
08:52:04 0536 Getting the CLR version.
08:52:04 0536 The CLR v4.0.30319 has been initialized successfully.
08:52:04 0536 Creating a new domain setup.
08:52:04 0536 Success.
08:52:04 0536 The 'shadow copy' is disabled.
08:52:04 0536 Creating a new application domain.
08:52:04 0536 Success.
08:52:04 0536 Getting the base directory for the domain.
08:52:04 0536 Success. The directory is 'C:\Users\SallyS\AppData\Local\miExcel\'.
08:52:04 0536 Searching for the Add-in Express core library.
08:52:04 0536 Success. The 'AddinExpress.MSO.2005.dll' file is found.
08:52:04 0536 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
08:52:04 0536 Assembly identity is 'AddinExpress.MSO.2005'.
08:52:04 0536 Success.
08:52:04 0536 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
08:52:04 0536 Success.
08:52:04 0536 Calling the managed registration procedure (DISPID = 1610743823).
08:52:09 1112 32 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\miExcel.AddinModule' registry key was created successfully for the 'miExcel.AddinModule' class: LoadBehavior=3
08:52:09 1112 32 bits. The 'HKCU\CLSID\{3134f228-9c9c-4f2a-ae6f-f029aef8498b}\InprocServer32' registry key was created successfully for the 'miExcel.AddinModule' class: C:\Users\SallyS\AppData\Local\miExcel\adxloader.miExcel.dll
08:52:09 1112 64 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\miExcel.AddinModule' registry key was created successfully for the 'miExcel.AddinModule' class: LoadBehavior=3
08:52:09 1112 64 bits. The 'HKCU\CLSID\{3134f228-9c9c-4f2a-ae6f-f029aef8498b}\InprocServer32' registry key was created successfully for the 'miExcel.AddinModule' class: C:\Users\SallyS\AppData\Local\miExcel\adxloader64.miExcel.dll
08:52:09 1112 The '/R "C:\Users\SallyS\AppData\Local\miExcel\adxloader.miExcel.dll"' registry value was created successfully for the 'miExcel.XLLModule' class.
08:52:09 1112 32 bits. The 'HKCU\CLSID\{8890f65c-33c7-3752-938d-cee07dbdd1a9}\InprocServer32' registry key was created successfully for the 'miExcel.XLLModule' class: mscoree.dll
08:52:09 1112 64 bits. The 'HKCU\CLSID\{8890f65c-33c7-3752-938d-cee07dbdd1a9}\InprocServer32' registry key was created successfully for the 'miExcel.XLLModule' class: mscoree.dll
08:52:11 0536 Registration success.
08:52:11 0536 The add-in registration process is completed with HRESULT = 0.


Loader

Add-in Express Loader Log File: 03/22/2018 08:52:21:202

Startup directory: C:\Users\SallyS\AppData\Local\miExcel\
Loader version: 8.8.4450.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Excel_16010.9029.2253.0_x86__8wekyb3d8bbwe\Office16\EXCEL.exe"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
08:52:21:202 3596 5640 Start.
08:52:21:202 3596 5640 Creating a new instance of the add-in loader.
08:52:21:202 3596 5640 Loading mscoree.dll
08:52:21:202 3596 5640 Success.
08:52:21:202 3596 5640 Loading the configuration from the system registry.
08:52:21:202 3596 5640 Getting the latest CLR version.
08:52:21:202 3596 5640 The latest CLR version is 'v4.0.30319'.
08:52:21:202 3596 5640 The configuration has been loaded successfully.
08:52:21:202 3596 5640 Runtime version: v4.0.30319.
08:52:21:202 3596 5640 Assembly name: miExcel, PublicKeyToken=8997CDA2B0DAD049.
08:52:21:202 3596 5640 Class name: miExcel.AddinModule.
08:52:21:202 3596 5640 Registry key: CLSID\{3134F228-9C9C-4F2A-AE6F-F029AEF8498B}.
08:52:21:202 3596 5640 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
08:52:21:202 3596 5640 Loading CLR: v4.0.30319.
08:52:21:202 3596 5640 Calling CLRCreateInstance method.
08:52:21:202 3596 5640 Success.
08:52:21:202 3596 5640 Calling GetRuntime method.
08:52:21:202 3596 5640 Success.
08:52:21:202 3596 5640 Checking if the hosting API of .NET Framework v4.0 beta is installed.
08:52:21:218 3596 5640 The hosting API is up to date.
08:52:21:218 3596 5640 Calling SetDefaultStartupFlags method.
08:52:21:218 3596 5640 Success.
08:52:21:218 3596 5640 Calling GetInterface method for the CorRuntimeHost interface.
08:52:21:218 3596 5640 Success.
08:52:21:218 3596 5640 Starting CLR...
08:52:21:218 3596 5640 Success.
08:52:21:218 3596 5640 Getting the CLR version.
08:52:21:218 3596 5640 The CLR v4.0.30319 has been initialized successfully.
08:52:21:218 3596 5640 Creating a new domain setup.
08:52:21:218 3596 5640 Success.
08:52:21:218 3596 5640 Getting the add-in directory.
08:52:21:218 3596 5640 Success. The directory is 'C:\Users\SallyS\AppData\Local\miExcel\'
08:52:21:233 3596 5640 The 'shadow copy' is disabled.
08:52:21:233 3596 5640 Creating a new application domain.
08:52:21:233 3596 5640 Success.
08:52:21:233 3596 5640 Creating an instance of the managed class. Assembly identity: 'miExcel, PublicKeyToken=8997CDA2B0DAD049'
08:52:21:999 3596 5640 Success.
08:52:21:999 3596 5640 Unwrapping the managed class.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Querying the add-in extensibility.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Querying the custom task panes.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Querying the ribbon extensibility.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Querying the form regions.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Querying the encryption provider.
08:52:22:280 3596 5640 The 'EncryptionProvider' interface is not supported.
08:52:22:280 3596 5640 Getting the dispid of the 'Dispose' method.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Getting the dispid of the 'InitializeLoaderService' method.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 Invoking the 'InitializeLoaderService' method.
08:52:22:280 3596 5640 Success.
08:52:22:280 3596 5640 The instance of the managed add-in class has been created successfully.
Posted 22 Mar, 2018 09:22:36 Top
Andrei Smolin


Add-in Express team


Posts: 18857
Joined: 2006-05-11
Mark,

What Excel build number are you using?

Please check if your XLL is mentioned in HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\Options. The valuse name is "OPEN" or "OPEN{an integer}"; the value's value is "/R {path to adxloader[64].{addin name}.dll}" e.g.

/R "C:\Users\andrej\AppData\Local\Default Company\MyAddin54\adxloader.MyAddin54.dll"

If yes, Excel doesn't read it for some reason. If no, this is an issue in Add-in Express.


Andrei Smolin
Add-in Express Team Leader
Posted 22 Mar, 2018 10:05:40 Top
Mark Meyer




Posts: 34
Joined: 2014-03-26
They are running Excel 2016 MSO (16.0.9029.2523) 32 bit - Home and Business 2016.
Version 1802 (Build 9029.2253 Microsoft Store)

The key is there and the path is correct.
Posted 22 Mar, 2018 10:15:57 Top
Andrei Smolin


Add-in Express team


Posts: 18857
Joined: 2006-05-11
Well, you may register the add-in (a correct loader file) right in Excel: see the Excel add-ins dialog. This workaround requires that you delete the add-in from the dialog before you uninstall the add-in.


Andrei Smolin
Add-in Express Team Leader
Posted 22 Mar, 2018 10:40:36 Top