Excel for Office 365 MSO (16.0.10730.20102 Click-to-Run) - "Start Screen" is missing after Intellisense Server installation

[Eugene Ischenko]

Hi Govert and all,

Hope you are doing well.

It seems that IntelliSense server installation somehow prevents "Start Screen" to appear in Excel. Excel just loads without any workbook opened.

Observed behavior is triggered by calling line shown below inside the AutoOpen method.

IntelliSenseServer.Install();

Is it a known behavior? If so, is there a workaround for it?

Thank you for Excel-DNA. It saved lots of lives.

[Govert van Drimmelen]

Hi,

 

This is known behaviour with no known fix – though not the same for all Excel versions.

The problems seemed to go away for a while and is now back.

 

See https://groups.google.com/forum/#!searchin/exceldna/splash%7Csort:date/exceldna/3fIunrFUbwY/uMyo_BuiBAAJ

And https://social.msdn.microsoft.com/Forums/office/en-US/a2b1b34e-5914-48df-bc19-71fa502477d2/excel-2016-bug-the-excel-window-shows-no-content-at-startup-if-an-xll-is-registered?forum=exceldev

 

I suggest you press the feedback button in Excel, and also post back to the MSDN forum discussion.

 

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

[Eugene Ischenko]

If I understood correctly, the issue described in threads you provided was reproduced for any .xll registered in any way. Issue resulted in Excel being opened with all workbooks closed, regardless of "Show the Start screen" option state. Attempts to reproduce the described issue following steps provided in this thread using sample XLLs from Excel 2013 XLL Software Development Kit did not succeed.

After additional investigation it looks like I've found the the way to reproduce my issue on a sample project.

We have 2 add-ins, one COM and the other Excel-DNA based. The Excel-DNA based add-in gets enabled from within ThisAddIn_Startup method of Com Add-in via Application.RegisterXLL(filename) method.

The issue I'm facing is occurring only when "Show the Start screen" option is enabled. Otherwise Excel loads default empty workbook. 

I understand that this is an unorthodox way of loading .xll add-ins, any ideas on how this can be fixed would be appreciated. Or is this the same Excel bug you've told about before just with some extra steps?

Excel-DNA Add-In version 0.34.6 and Excel-DNA IntelliSense Extension version 1.1.0 are used.

Thanks,

Eugene.

[Eugene Ischenko]

Url to sample project I used to reproduce the issue: https://github.com/evgen-ischenko/TestXllProject