2
votes

I'm currently using VSTO. Normally, when I load a new project, the first thing that appears is a worksheet that Visual Studio created automatically. But now, this page is totally blue, like this

enter image description here

When I try to debug the project as it stands, the workbook will be loaded, but the worksheet will not, like this

enter image description here

The last thing I did before having this problem was install Excel DNA in another project that I'm working on.

I've already tried to search for solution online but I haven't found anything.

I'm using: Windows 10 / Microsoft Office 365 ProPlus / Visual Studio 2017

1
Did you try removing Excel-DNA (and perhaps repairing VSTO) to see if that makes any difference?Cindy Meister
yes, i did. The problem remained.asa

1 Answers

2
votes

This might be an Excel 2016 bug that is triggered when you have an .xll add-in installed - presumably the Excel-DNA add-in in your case, but any C/C++ .xll add-in would also cause this behaviour.

There was a discussion on the MSDN forums which seems to indicate the bug has been fixed in recent Excel 2016 updates.