UDF's returning #VALUE errors temporarily

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

UDF's returning #VALUE errors temporarily
 
Subscribe
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi, the document management system simply copies a workbook into a new location and opens Excel. We now have another client who is experiencing this issue with the formulas and it happens 'at random'.

Here are their logs in case this helps?

ADXREGISTRATOR.LOG

Add-in Express Registrator Log File: 09/22/2017 09:00:24

Installation directory: C:\Program Files\Business Fitness\HowNow Smart Workpapers\
Registrator version: 8.0.4330.0
Operating System: Microsoft Windows 7 Professional Service Pack 1 (build 7601), 32-bit
Process Owner: Administrator
Command Line: adxregistrator.exe /install="Workpapers.Next.Addin.dll" /privileges=user
Run 'As Administrator': Yes
Process Elevated: Yes
Integrity Level: High
UAC (User Account Control): Off
--------------------------------------------------------------
09:00:24 0164 Starting the add-in registration process.
09:00:24 0164 Loading mscoree.dll
09:00:24 0164 Success.
09:00:24 0164 .NET Framework installation directory:
09:00:24 0164 The latest version of .NET Framework: 'v4.0.30319'
09:00:24 0164 Loading CLR: v4.0.30319.
09:00:24 0164 Calling CLRCreateInstance method.
09:00:24 0164 Success.
09:00:24 0164 Calling GetRuntime method.
09:00:24 0164 Success.
09:00:24 0164 Checking if the hosting API of .NET Framework v4.0 beta is installed.
09:00:24 0164 The hosting API is up to date.
09:00:24 0164 Calling GetInterface method for the CorRuntimeHost interface.
09:00:24 0164 Success.
09:00:24 0164 Starting CLR...
09:00:24 0164 Success.
09:00:24 0164 Getting the CLR version.
09:00:24 0164 The CLR v4.0.30319 has been initialized successfully.
09:00:24 0164 Creating a new domain setup.
09:00:24 0164 Success.
09:00:24 0164 Getting the add-in directory.
09:00:24 0164 Success. The directory is 'C:\Program Files\Business Fitness\HowNow Smart Workpapers\'
09:00:24 0164 The 'shadow copy' is disabled.
09:00:24 0164 Creating a new application domain.
09:00:24 0164 Success.
09:00:24 0164 Getting the base directory for the domain.
09:00:24 0164 Success. The directory is 'C:\Program Files\Business Fitness\HowNow Smart Workpapers\'.
09:00:24 0164 Searching for the Add-in Express core library.
09:00:24 0164 Success. The 'AddinExpress.MSO.2005.dll' file is found.
09:00:24 0164 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
09:00:24 0164 Assembly identity is 'AddinExpress.MSO.2005'.
09:00:24 0164 Success.
09:00:24 0164 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
09:00:24 0164 Success.
09:00:24 0164 Calling the managed registration procedure (DISPID = 1610743823).
09:00:24 0660 The '/R "C:\Program Files\Business Fitness\HowNow Smart Workpapers\adxloader.Workpapers.Next.Addin.dll"' registry value was created successfully for the 'Workpapers.Next.XLLModule' class.
09:00:24 0164 Success.
09:00:24 0164 The add-in registration process is completed with HRESULT = 0.




ADXLOADER.LOG


Add-in Express Loader Log File: 09/26/2017 10:37:53:871

Startup directory: C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\
Loader version: 8.6.4408.0
Operating System: Microsoft Windows 7 Professional Service Pack 1 (build 7601), 32-bit
Process Owner: Administrator
Command Line: "C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE" /dde
Run 'As Administrator': Yes
Process Elevated: Yes
Integrity Level: High
UAC (User Account Control): Off
------------------------------------------------------------------------
10:37:53:873 1820 6284 Creating a new instance of the XLL loader.
10:37:53:873 1820 6284 Loading mscoree.dll
10:37:53:874 1820 6284 Success.
10:37:53:874 1820 6284 Getting the CLSID of the managed XLL class.
10:37:53:874 1820 6284 Success.
10:37:53:874 1820 6284 Loading the configuration from the system registry.
10:37:53:874 1820 6284 Getting the latest CLR version.
10:37:53:875 1820 6284 The latest CLR version is 'v4.0.30319'.
10:37:53:875 1820 6284 The configuration has been loaded successfully.
10:37:53:875 1820 6284 Runtime version: v4.0.30319.
10:37:53:875 1820 6284 Assembly name: Workpapers.Next.Addin.
10:37:53:875 1820 6284 Class name: Workpapers.Next.XLLModule.
10:37:53:875 1820 6284 Registry key: CLSID\{AD5BAD6F-7A3B-33D8-A336-637850011F7A}.
10:37:53:875 1820 6284 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
10:37:53:875 1820 6284 Loading CLR: v4.0.30319.
10:37:53:875 1820 6284 Calling CLRCreateInstance method.
10:37:53:875 1820 6284 Success.
10:37:53:875 1820 6284 Calling GetRuntime method.
10:37:53:876 1820 6284 Success.
10:37:53:876 1820 6284 Checking if the hosting API of .NET Framework v4.0 beta is installed.
10:37:53:883 1820 6284 The hosting API is up to date.
10:37:53:883 1820 6284 Calling GetInterface method for the CorRuntimeHost interface.
10:37:53:883 1820 6284 Success.
10:37:53:883 1820 6284 Starting CLR...
10:37:53:883 1820 6284 Success.
10:37:53:883 1820 6284 Getting the CLR version.
10:37:53:883 1820 6284 The CLR v4.0.30319 has been initialized successfully.
10:37:53:883 1820 6284 Creating a new domain setup.
10:37:53:884 1820 6284 Success.
10:37:53:884 1820 6284 Getting the add-in directory.
10:37:53:884 1820 6284 Success. The directory is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\'
10:37:53:885 1820 6284 The configuration file is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\Workpapers.Next.Addin.dll.config'
10:37:53:885 1820 6284 The 'shadow copy' is disabled.
10:37:53:885 1820 6284 Creating a new application domain.
10:37:53:890 1820 6284 Success.
10:37:53:890 1820 6284 Getting the base directory for the domain.
10:37:53:890 1820 6284 Success. The directory is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\'.
10:37:53:890 1820 6284 Opening adxloader.dll.manifest.
10:37:53:891 1820 6284 Success. The manifest is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\adxloader.dll.manifest'.
10:37:53:891 1820 6284 Getting the 'assemblyIdentity' element.
10:37:53:891 1820 6284 Success.
10:37:53:891 1820 6284 Getting the 'name' attribute.
10:37:53:891 1820 6284 Success. The name is 'Workpapers.Next.Addin'.
10:37:53:891 1820 6284 Getting the 'name' attribute.
10:37:53:891 1820 6284 Success. The class name is 'Workpapers.Next.XLLModule'.
10:37:53:891 1820 6284 Attempting to create a new instance of the XLL class.
10:37:53:913 1820 6284 Success.
10:37:53:913 1820 6284 Getting the dispid of the 'autoOpen' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'autoClose' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'autoAdd' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'autoRemove' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'autoFree' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'autoFree12' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'addInManagerInfo' method.
10:37:53:914 1820 6284 Success.
10:37:53:914 1820 6284 Getting the dispid of the 'addInManagerInfo12' method.
10:37:53:915 1820 6284 Success.
10:37:53:915 1820 6284 Getting the dispid of the 'Dispose' method.
10:37:53:915 1820 6284 Success.
10:37:53:915 1820 6284 Getting the dispid of the 'initialize4' method.
10:37:53:915 1820 6284 Success.
10:37:53:915 1820 6284 Invoking the 'initialize4' method.
10:37:53:950 1820 6284 Success.
10:37:53:950 1820 6284 The instance of the managed XLL class has been created successfully.
10:37:53:950 1820 6284 Forwarding xlAutoOpen to the managed code.
10:37:53:967 1820 6284 Success.
10:37:54:355 1820 6284 Start.
10:37:54:355 1820 6284 Creating a new instance of the add-in loader.
10:37:54:355 1820 6284 Success.
10:37:54:355 1820 6284 Loading the configuration from the system registry.
10:37:54:356 1820 6284 Getting the latest CLR version.
10:37:54:356 1820 6284 The latest CLR version is 'v4.0.30319'.
10:37:54:356 1820 6284 The configuration has been loaded successfully.
10:37:54:356 1820 6284 Runtime version: v4.0.30319.
10:37:54:356 1820 6284 Assembly name: Workpapers.Next.Addin.
10:37:54:356 1820 6284 Class name: Workpapers.Next.AddinModule.
10:37:54:356 1820 6284 Registry key: CLSID\{80E92C65-0F44-465B-82D2-C4B368238E6B}.
10:37:54:356 1820 6284 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
10:37:54:356 1820 6284 Creating an instance of the managed class. Assembly identity: 'Workpapers.Next.Addin'
10:37:54:461 1820 6284 Success.
10:37:54:461 1820 6284 Unwrapping the managed class.
10:37:54:464 1820 6284 Success.
10:37:54:464 1820 6284 Querying the add-in extensibility.
10:37:54:465 1820 6284 Success.
10:37:54:465 1820 6284 Querying the custom task panes.
10:37:54:465 1820 6284 Success.
10:37:54:465 1820 6284 Querying the ribbon extensibility.
10:37:54:465 1820 6284 Success.
10:37:54:465 1820 6284 Querying the form regions.
10:37:54:465 1820 6284 Success.
10:37:54:465 1820 6284 Querying the encryption provider.
10:37:54:465 1820 6284 The 'EncryptionProvider' interface is not supported.
10:37:54:465 1820 6284 Getting the dispid of the 'Dispose' method.
10:37:54:467 1820 6284 Success.
10:37:54:467 1820 6284 The instance of the managed add-in class has been created successfully.
10:37:55:308 1820 6284 Forwarding xlAddInManagerInfo12 to the managed code.
10:37:55:313 1820 6284 Success.
10:37:55:581 1820 6284 Forwarding xlAutoRemove to the managed code.
10:37:55:582 1820 6284 Success.
10:37:55:583 1820 6284 Forwarding xlAutoClose to the managed code.
10:37:55:583 1820 6284 Success.
10:37:55:599 1820 6284 Creating a new instance of the XLL loader.
10:37:55:599 1820 6284 Success.
10:37:55:599 1820 6284 Getting the CLSID of the managed XLL class.
10:37:55:599 1820 6284 Success.
10:37:55:599 1820 6284 Loading the configuration from the system registry.
10:37:55:599 1820 6284 Getting the latest CLR version.
10:37:55:600 1820 6284 The latest CLR version is 'v4.0.30319'.
10:37:55:600 1820 6284 The configuration has been loaded successfully.
10:37:55:600 1820 6284 Runtime version: v4.0.30319.
10:37:55:600 1820 6284 Assembly name: Workpapers.Next.Addin.
10:37:55:600 1820 6284 Class name: Workpapers.Next.XLLModule.
10:37:55:600 1820 6284 Registry key: CLSID\{AD5BAD6F-7A3B-33D8-A336-637850011F7A}.
10:37:55:600 1820 6284 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
10:37:55:600 1820 6284 Getting the base directory for the domain.
10:37:55:600 1820 6284 Success. The directory is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\'.
10:37:55:600 1820 6284 Opening adxloader.dll.manifest.
10:37:55:600 1820 6284 Success. The manifest is 'C:\Users\user1\AppData\Local\Business Fitness\HowNow Smart Workpapers\2.2.0.27\adxloader.dll.manifest'.
10:37:55:600 1820 6284 Getting the 'assemblyIdentity' element.
10:37:55:600 1820 6284 Success.
10:37:55:600 1820 6284 Getting the 'name' attribute.
10:37:55:600 1820 6284 Success. The name is 'Workpapers.Next.Addin'.
10:37:55:600 1820 6284 Getting the 'name' attribute.
10:37:55:600 1820 6284 Success. The class name is 'Workpapers.Next.XLLModule'.
10:37:55:600 1820 6284 Attempting to create a new instance of the XLL class.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoOpen' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoClose' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoAdd' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoRemove' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoFree' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'autoFree12' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'addInManagerInfo' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'addInManagerInfo12' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'Dispose' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Getting the dispid of the 'initialize4' method.
10:37:55:601 1820 6284 Success.
10:37:55:601 1820 6284 Invoking the 'initialize4' method.
10:37:55:602 1820 6284 Success.
10:37:55:602 1820 6284 The instance of the managed XLL class has been created successfully.
10:37:55:602 1820 6284 Forwarding xlAutoAdd to the managed code.
10:37:55:603 1820 6284 Success.
10:37:55:604 1820 6284 Forwarding xlAutoOpen to the managed code.
10:37:55:606 1820 6284 Success.
Posted 26 Sep, 2017 19:11:13 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
Hello Sean,

Sean Devenish writes:
and opens Excel


How does it do this? Is there a possibility that it starts Excel by creating an Excel.Application object? The point is: Excel doesn't load Excel add-ins (XLLs and Automation add-ins) when started programmatically.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 27 Sep, 2017 02:17:48 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
The add-in shows as 'active' in the 'File'/'Options'/'Addins' menu, so we have ruled that out.
Posted 27 Sep, 2017 02:54:02 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
I've started Excel via a VBA macro: my XLL add-in is marked as active, still, a test function isn't available when I use Formula AutoComplete and referencing the function in a formula produces #NAME? not #VALUE!.

I'd like to check the settings of the function and its parameters. Could you please send me the InitializeComponent method which is called from the constructor of your XLL module. You can find the support email address in {Add-in Express installation folder}\readme.txt. Please make sure your email contains a link to this topic.

Also, please send me a screenshot showing the About dialog of Excel from that machine. Finally, I'd like to have an example of the workbook created by that document management system.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 27 Sep, 2017 04:44:16 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi Andrei,

I have sent an email to the support address with the details you requested.

A couple of things to note:
1) The behaviour is only observed when they first open it after it is created. After closing it and re-opening it the formulas work fine.
2) While the formulas are returning $VALUE!, the XLL Addin is still marked as active, and the formulas also appear when we use Formula AutoComplete.

Thanks for this, it has us scratching our heads!
Posted 03 Oct, 2017 18:04:07 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
Hello Sean,

Thank you for sending me this info.

Sean Devenish writes:
The behaviour is only observed when they first open it after it is created.


The workbook you sent to me, has it ever been opened? The workbook doesn't contain some named ranges or I cannot find them: TR1*, TR4*, TR5*, TR7*, etc. I assume this is okay, correct?

Does the user start Excel or EXCEL.EXE is started by the document management system?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 04 Oct, 2017 10:05:52 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi Andrew,

This one will have been opened, excel.exe is started by the document management system.

The named ranges are fine. I note that we created a formula called nowstring which returns the current time as a formatted string per your previous suggestion, and this formulas also returns #VALUE!
Posted 04 Oct, 2017 11:11:22 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
Hello Sean,

I've sent you an email with a download link for an XLL add-in based on the InitializeComponent() method that you sent me. Please check if the issue is reproducible with this add-in.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 Oct, 2017 05:14:51 Top
Sean Devenish




Posts: 55
Joined: 2015-11-30
Hi,

we attempted to install this for the user but it requires administrator privileges which they don't have (running on a terminal server). Can we get a version of this test file that does not require administrator privileges (our installer doesn't as it installs to the users local app data).
Posted 05 Oct, 2017 23:12:18 Top
Andrei Smolin


Add-in Express team


Posts: 14129
Joined: 2006-05-11
Hello Sean,

I start the .MSI and it installs with the user permissions if I use all default settings.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 06 Oct, 2017 02:28:27 Top