Upgrading to Office 2016 Reference Error: Microsoft.Office.Interop.Excel

vb.net visual-studio-2015 excel-2016 office-2016
Fly Guy picture Fly Guy · Oct 19, 2015 · Viewed 22.7k times · Source

Visual Studio 2015 is giving me an error stating that the "Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found." I just started getting this error after upgrading to Office 2016 from 2013.

I don't have a .NET tab in my References section to add this reference. MSDN is only giving me an option to download the Primary Interop Assembly for Visual Studio 2013 and it is not fixing my issue. I still don't see the .NET tab.

How do I fix these reference errors?

Answer

Michael Ribbons picture Michael Ribbons · Dec 9, 2015

With Office 2016 we can now add a reference again.

Delete your existing Microsoft.Office.Interop.Excel reference.

Right click references, add reference

Select COM Search for Excel Check Microsoft.Office 16.0 Object Library Click OK

Related questions

VB.NET Visual Basic Power Packs not working on VS2015?

I have downloaded the VS Basic Power Packs from the link here https://msdn.microsoft.com/en-us/library/cc488277.aspx but I have no idea why it does not appear in my project toolbox. I have also added the project …

Read More
Prevent Visual Studio 2015 from removing line continuation characters (_) in VB.NET files

I'm opening some old VB.NET projects in Visual Studio 2015 and when I edit the code, VS changes the syntax: It removes "_" in concatenations: 'Before myString = "ABC" & _ "DEF" 'After myString = "ABC" & "DEF" or add a space before !: 'Before …

Read More
Bold or italic in C# or VB documentation comments?

Is there a way to use bold or italic inside documentation comments? Something like: /// <summary>Cleanup method. This is <b>recommended</b> way of cleanup.</summary> public void CleanAll(); List of predefined …

Read More