Excel Automation Add-In Loaded but not functioning

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

Excel Automation Add-In Loaded but not functioning
 
Larry Sater




Posts: 16
Joined: 2016-10-26
I have installed my Excel add-in on a PC and Excel shows it to be loaded (checked in the "Add-Ins" window) however when I type in my UDF in a cell it does not recognize it.

Other notes:

1. I am not an administrator on this PC, but I was able to install it without any problems.
2. I also have a COM add-in and it seems to be functioning okay - I can see its ribbon in the UI.

Any ideas on what to look at / try next?

Thanks!

Here is my adxloader.log file
Add-in Express Loader Log File: 03/07/2017 18:20:16:972

Startup directory: C:\Users\sater\AppData\Local\AgVantis\QueryTool\
Loader version: 8.4.4395.0
Operating System: Microsoft Windows Server 2012 R2 Standard Edition (build 9600), 64-bit
Process Owner: User
Command Line: "C:\Program Files (x86)\Microsoft Office\Office16\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
18:20:16:973 3060 13888 Start.
18:20:16:973 3060 13888 The minimum supported Office version is 14
18:20:16:973 3060 13888 The host's version is 16.0.4266.0
18:20:16:973 3060 13888 Creating a new instance of the add-in loader.
18:20:16:973 3060 13888 Loading mscoree.dll
18:20:16:973 3060 13888 Success.
18:20:16:973 3060 13888 Loading the configuration from the system registry.
18:20:16:974 3060 13888 Getting the latest CLR version.
18:20:16:974 3060 13888 The latest CLR version is 'v4.0.30319'.
18:20:16:974 3060 13888 The configuration has been loaded successfully.
18:20:16:974 3060 13888 Runtime version: v4.0.30319.
18:20:16:974 3060 13888 Assembly name: QueryTool, PublicKeyToken=3D4DED7537BFADBE.
18:20:16:974 3060 13888 Class name: QueryTool.QueryToolUIModule.
18:20:16:974 3060 13888 Registry key: CLSID\{F1E4BEF4-8239-4278-BDE9-D90E74F58413}.
18:20:16:974 3060 13888 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
18:20:16:974 3060 13888 Loading CLR: v4.0.30319.
18:20:16:974 3060 13888 Calling CLRCreateInstance method.
18:20:16:974 3060 13888 Success.
18:20:16:974 3060 13888 Calling GetRuntime method.
18:20:16:975 3060 13888 Success.
18:20:16:975 3060 13888 Checking if the hosting API of .NET Framework v4.0 beta is installed.
18:20:17:000 3060 13888 The hosting API is up to date.
18:20:17:000 3060 13888 Calling GetInterface method for the CorRuntimeHost interface.
18:20:17:000 3060 13888 Success.
18:20:17:000 3060 13888 Starting CLR...
18:20:17:000 3060 13888 Success.
18:20:17:000 3060 13888 Getting the CLR version.
18:20:17:000 3060 13888 The CLR v4.0.30319 has been initialized successfully.
18:20:17:000 3060 13888 Creating a new domain setup.
18:20:17:004 3060 13888 Success.
18:20:17:004 3060 13888 Getting the add-in directory.
18:20:17:004 3060 13888 Success. The directory is 'C:\Users\sater\AppData\Local\AgVantis\QueryTool\'
18:20:17:005 3060 13888 The configuration file is 'C:\Users\sater\AppData\Local\AgVantis\QueryTool\QueryTool.dll.config'
18:20:17:005 3060 13888 The 'shadow copy' is disabled.
18:20:17:005 3060 13888 Creating a new application domain.
18:20:17:018 3060 13888 Success.
18:20:17:018 3060 13888 Creating an instance of the managed class. Assembly identity: 'QueryTool, PublicKeyToken=3D4DED7537BFADBE'
18:20:17:198 3060 13888 Success.
18:20:17:198 3060 13888 Unwrapping the managed class.
18:20:17:225 3060 13888 Success.
18:20:17:225 3060 13888 Querying the add-in extensibility.
18:20:17:226 3060 13888 Success.
18:20:17:226 3060 13888 Querying the custom task panes.
18:20:17:226 3060 13888 Success.
18:20:17:226 3060 13888 Querying the ribbon extensibility.
18:20:17:226 3060 13888 Success.
18:20:17:226 3060 13888 Querying the form regions.
18:20:17:226 3060 13888 Success.
18:20:17:226 3060 13888 Querying the encryption provider.
18:20:17:227 3060 13888 The 'EncryptionProvider' interface is not supported.
18:20:17:227 3060 13888 Getting the dispid of the 'Dispose' method.
18:20:17:231 3060 13888 Success.
18:20:17:232 3060 13888 The instance of the managed add-in class has been created successfully.

And adxregistrator.log

Add-in Express Registrator Log File: 03/07/2017 18:33:11

Installation directory: C:\Windows\Installer\
Registrator version: 8.4.4395.0
Operating System: Microsoft Windows Server 2012 R2 Standard Edition (build 9600), 64-bit
Process Owner: User
Command Line: "C:\Windows\Installer\MSI6DA5.tmp" /install="C:\Users\sater\AppData\Local\AgVantis\QueryTool\QueryTool.dll" /privileges=user
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
--------------------------------------------------------------
18:33:11 0312 Starting the add-in registration process.
18:33:11 0312 Loading mscoree.dll
18:33:11 0312 Success.
18:33:11 0312 .NET Framework installation directory:
18:33:11 0312 The latest version of .NET Framework: 'v4.0.30319'
18:33:11 0312 Loading CLR: v4.0.30319.
18:33:11 0312 Calling CLRCreateInstance method.
18:33:11 0312 Success.
18:33:11 0312 Calling GetRuntime method.
18:33:11 0312 Success.
18:33:11 0312 Checking if the hosting API of .NET Framework v4.0 beta is installed.
18:33:11 0312 The hosting API is up to date.
18:33:11 0312 Calling GetInterface method for the CorRuntimeHost interface.
18:33:11 0312 Success.
18:33:11 0312 Starting CLR...
18:33:11 0312 Success.
18:33:11 0312 Getting the CLR version.
18:33:11 0312 The CLR v4.0.30319 has been initialized successfully.
18:33:11 0312 Creating a new domain setup.
18:33:11 0312 Success.
18:33:11 0312 The 'shadow copy' is disabled.
18:33:11 0312 Creating a new application domain.
18:33:11 0312 Success.
18:33:11 0312 Getting the base directory for the domain.
18:33:11 0312 Success. The directory is 'C:\Users\sater\AppData\Local\AgVantis\QueryTool\'.
18:33:11 0312 Searching for the Add-in Express core library.
18:33:11 0312 Success. The 'AddinExpress.MSO.2005.dll' file is found.
18:33:11 0312 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
18:33:11 0312 Assembly identity is 'AddinExpress.MSO.2005'.
18:33:11 0312 Success.
18:33:11 0312 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
18:33:11 0312 Success.
18:33:11 0312 Calling the managed registration procedure (DISPID = 1610743823).
18:33:11 0816 The '/R "C:\Users\sater\AppData\Local\AgVantis\QueryTool\adxloader.QueryTool.dll"' registry value was created successfully for the 'QueryTool.XLLModule' class.
18:33:11 0312 Registration success.
18:33:11 0312 The add-in registration process is completed with HRESULT = 0.
Posted 07 Mar, 2017 19:31:25 Top
Gerry Rempel




Posts: 15
Joined: 2009-02-05
Do you get #NAME in your cell where your formula should evaluate?

Thanks,
Gerry
Posted 07 Mar, 2017 20:14:28 Top
Larry Sater




Posts: 16
Joined: 2016-10-26
Yes - I get #NAME? in the cell. Help text next to it is "The formula contains unrecognized text".

Thanks.
Posted 08 Mar, 2017 09:19:20 Top
Gerry Rempel




Posts: 15
Joined: 2009-02-05
I sometimes get this problem, but it is intermittent. I can't reliably reproduce it, the setup probably works 95% of the time. I have an open question on this topic, but all I got was a request to send the installation logs. I haven't heard back yet.

Thanks,
Posted 08 Mar, 2017 11:52:58 Top
Larry Sater




Posts: 16
Joined: 2016-10-26
I have tried this on several PCs, even PCs with Excel 2016 and it has worked all the time. It just seems to be this machine (which is a server, but that really shouldn't make a difference should it?). It will be used interactively with a person logging into the server.

I had our system administrator log into the server (admin rights), run Excel and once again, the add-ins are loaded properly, but the UDFs are not functioning.

I did notice, however, that when I create a blank worksheet the Macro and VBA buttons are grayed out as well. Perhaps this is related. I checked my Trust Settings and they are fine, I believe.

Any thoughts would be appreciated.
Posted 08 Mar, 2017 18:11:59 Top
Andrei Smolin


Add-in Express team


Posts: 14094
Joined: 2006-05-11
Hello Larry and Gerry,

I'm sorry for not responding earlier; yesterday was an official holiday here.

Larry,

The log files are okay. Please check if the Excel Automation add-in is mentioned on the Add-ins tab of the dialog window that you open via File | Options. Make sure that the '/R "C:\Users\sater\AppData\Local\AgVantis\QueryTool\adxloader.QueryTool.dll' registry value is actually created in HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\{Excel version}.0\Excel\Options.

Larry Sater writes:
I did notice, however, that when I create a blank worksheet the Macro and VBA buttons are grayed out as well. Perhaps this is related.


This may relate. Make sure VBA is enabled on that machine. I suppose Excel is installed without VBA and this causes the issue.

Gerry Rempel writes:
I haven't heard back yet.


I haven't received an email with logs from you. Could you please resend it?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Mar, 2017 03:14:49 Top
Larry Sater




Posts: 16
Joined: 2016-10-26
Thanks Andrei,

The registry checked out fine. I worked with this yesterday and finally got this working by having our SysAdmin reinstall Excel. This time he selected "Office Shared Features" which he must not have done the first time. After that I was able to open up Excel, the Macro/VBA buttons are enabled and my UDFs are working.

Thanks again!
Posted 10 Mar, 2017 10:28:47 Top
John Putman




Posts: 15
Joined: 2012-12-02
I have just opened a similar issue in the following thread:
https://www.add-in-express.com/forum/read.php?FID=5&TID=14428&MID=73904


Our issue is that a client has the Trust Center Settings / Add-ins / Require Application Add-ins to be signed by Trusted Publisher checked off. While we have the COM Add-In signed and in the Trusted Publisher store, I don't know how to do the same for the Automation Add-In, since it is registered within the COM addin to the mscoree.dll.

Is this a possible cause for your case as well? If you check off on this option, do your UDF's work?

-john putman
Posted 10 Mar, 2017 16:30:24 Top
Larry Sater




Posts: 16
Joined: 2016-10-26
Yes, we did try that and it did not work. Installing the "Office Shared Features" as indicated above is what got mine to start working.

Good luck with your issue.
Posted 10 Mar, 2017 16:42:56 Top