Excel 2016 64-bit Missing Blank Startup Workbook with XLL Addin added to a COM Addin

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

Excel 2016 64-bit Missing Blank Startup Workbook with XLL Addin added to a COM Addin
The blank workbook does appear in Excel 2013 32-bit. If you remove the XLL addin then the blank workbook returns when Excel 2016 64-bit is first started. 
Subscribe
Jim J




Posts: 9
Joined: 2019-03-26
You should be able to reproduce the issue in Excel 2016 64-bit by doing the following.

1.)Options-->General--> unchecking the "Show the Start screen when this application starts".
2.)Options-->Save--> check the "Don't show the Backstage when opening or saving files with keyboard shortcuts".
3.)Create a new ADX COM Addin
4.)Register the addin and start Excel. The addin should load and a blank workbook should appear immediately.
5.)Close Excel.
6.)Unregister the addin.
7.)Add an ADX XLL Module.
8.)Re-Register the Addin and start Excel. A blank workbook no longer appears at startup.

This issue does not happen when using Excel 2013 32bit.

My exact version of Excel is "Microsoft Excel 2016 MSO(16.0.11328.20220) 64-bit".

Below is my adxloader log file.
Add-in Express Loader Log File: 03/26/2019 23:09:32:603

Startup directory: C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\
Loader version: 9.2.4635.0
Operating System: Microsoft Windows 10 Enterprise Edition (build 17763), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
23:09:32:603 2840 0352 The minimum supported Office version is 10
23:09:32:603 2840 0352 The host's version is 16.0.11328.20222
23:09:32:603 2840 0352 Creating a new instance of the XLL loader.
23:09:32:603 2840 0352 Loading mscoree.dll
23:09:32:603 2840 0352 INFO: Assembly codebase - C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\TestAddin.dll.
23:09:32:603 2840 0352 INFO: Assembly version - 1.0.0.0.
23:09:32:603 2840 0352 Success.
23:09:32:603 2840 0352 Getting the CLSID of the managed XLL class.
23:09:32:603 2840 0352 Success.
23:09:32:603 2840 0352 Loading the configuration from the system registry.
23:09:32:603 2840 0352 Getting the latest CLR version.
23:09:32:603 2840 0352 The latest CLR version is 'v4.0.30319'.
23:09:32:603 2840 0352 The configuration has been loaded successfully.
23:09:32:619 2840 0352 Runtime version: v4.0.30319.
23:09:32:619 2840 0352 Assembly name: TestAddin, PublicKeyToken=c13acbcdead6de17.
23:09:32:619 2840 0352 Class name: TestAddin.XLLTestAddinUDFs.
23:09:32:619 2840 0352 Registry key: CLSID\{9F4231C7-F2D7-3E8D-A6C2-26C583DF27A0}.
23:09:32:619 2840 0352 Attempting to create a new instance of the managed XLL class: CLR - v4.0.30319
23:09:32:619 2840 0352 Loading CLR: v4.0.30319.
23:09:32:619 2840 0352 Calling CLRCreateInstance method.
23:09:32:619 2840 0352 Success.
23:09:32:619 2840 0352 Calling GetRuntime method.
23:09:32:619 2840 0352 Success.
23:09:32:619 2840 0352 Checking if the hosting API of .NET Framework v4.0 beta is installed.
23:09:32:634 2840 0352 The hosting API is up to date.
23:09:32:634 2840 0352 Calling SetDefaultStartupFlags method.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Calling GetInterface method for the CorRuntimeHost interface.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Starting CLR...
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the CLR version.
23:09:32:634 2840 0352 The CLR v4.0.30319 has been initialized successfully.
23:09:32:634 2840 0352 Creating a new domain setup.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the add-in directory.
23:09:32:634 2840 0352 Success. The directory is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\'
23:09:32:634 2840 0352 The 'shadow copy' is disabled.
23:09:32:634 2840 0352 Creating a new application domain.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the base directory for the domain.
23:09:32:634 2840 0352 Success. The directory is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\'.
23:09:32:634 2840 0352 Opening adxloader.dll.manifest.
23:09:32:634 2840 0352 Success. The manifest is 'C:\Users\Jim\Documents\Visual Studio 2017\Projects\TestAddin\TestAddin\bin\Debug\adxloader.dll.manifest'.
23:09:32:634 2840 0352 Getting the 'assemblyIdentity' element.
23:09:32:634 2840 0352 Success.
23:09:32:634 2840 0352 Getting the 'name' attribute.
23:09:32:634 2840 0352 Success. The name is 'TestAddin, PublicKeyToken=c13acbcdead6de17'.
23:09:32:634 2840 0352 Getting the 'name' attribute.
23:09:32:634 2840 0352 Success. The class name is 'TestAddin.XLLTestAddinUDFs'.
23:09:32:634 2840 0352 Attempting to create a new instance of the XLL class.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoOpen' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoClose' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoAdd' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoRemove' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoFree' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'autoFree12' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'addInManagerInfo' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'addInManagerInfo12' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'Dispose' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Getting the dispid of the 'initialize4' method.
23:09:32:666 2840 0352 Success.
23:09:32:666 2840 0352 Invoking the 'initialize4' method.
23:09:32:760 2840 0352 Success.
23:09:32:760 2840 0352 The instance of the managed XLL class has been created successfully.
23:09:32:760 2840 0352 Forwarding xlAutoOpen to the managed code.
23:09:32:775 2840 0352 Success.
23:09:32:791 2840 0352 Start.
23:09:32:791 2840 0352 The minimum supported Office version is 10
23:09:32:791 2840 0352 The host's version is 16.0.11328.20222
23:09:32:791 2840 0352 Creating a new instance of the add-in loader.
23:09:32:791 2840 0352 Success.
23:09:32:791 2840 0352 Loading the configuration from the system registry.
23:09:32:791 2840 0352 Getting the latest CLR version.
23:09:32:791 2840 0352 The latest CLR version is 'v4.0.30319'.
23:09:32:791 2840 0352 The configuration has been loaded successfully.
23:09:32:791 2840 0352 Runtime version: v4.0.30319.
23:09:32:791 2840 0352 Assembly name: TestAddin, PublicKeyToken=C13ACBCDEAD6DE17.
23:09:32:791 2840 0352 Class name: TestAddin.AddinModule.
23:09:32:791 2840 0352 Registry key: CLSID\{322A357C-C31C-47FC-A442-94D869CDFF25}.
23:09:32:791 2840 0352 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
23:09:32:791 2840 0352 Creating an instance of the managed class. Assembly identity: 'TestAddin, PublicKeyToken=C13ACBCDEAD6DE17'
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Unwrapping the managed class.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the add-in extensibility.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the custom task panes.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the ribbon extensibility.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the form regions.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Querying the encryption provider.
23:09:32:806 2840 0352 The 'EncryptionProvider' interface is not supported.
23:09:32:806 2840 0352 Getting the dispid of the 'Dispose' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Getting the dispid of the 'InitializeLoaderService' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 Invoking the 'InitializeLoaderService' method.
23:09:32:806 2840 0352 Success.
23:09:32:806 2840 0352 The instance of the managed add-in class has been created successfully.
23:09:40:197 2840 0352 Forwarding xlAddInManagerInfo12 to the managed code.
23:09:40:213 2840 0352 Success.
23:09:46:884 2840 0352 Forwarding xlAutoClose to the managed code.
23:09:46:884 2840 0352 Success.
Posted 26 Mar, 2019 22:16:57 Top
Dmitry Kostochko


Add-in Express team


Posts: 2811
Joined: 2004-04-05
Hi Jim,

Thank you for the detailed description.

You have run into an Excel 2016 bug, please have a look at the following threads:
Excel 2016 bug: the Excel window shows no content at startup if an XLL is registered
Strange : Excel not properly started with latest Office 2016 update + ExcelDna AddIn

The issue was reported as fixed last year but it seems it is back again. Please try to update your Office installation or report the issue to Microsoft again.
Posted 27 Mar, 2019 03:29:08 Top
Jim J




Posts: 9
Joined: 2019-03-26
Thanks for the quick reply Dmitry.

The links you provided were helpful and now that I know this is an Excel 2016 bug I will file it for my records.

Thanks,
Jim
Posted 27 Mar, 2019 11:31:26 Top
Dmitry Kostochko


Add-in Express team


Posts: 2811
Joined: 2004-04-05
Hi Jim,

Thank you for keeping us informed.
Posted 28 Mar, 2019 03:17:38 Top