excelvisual-studiovstooffice-addinsexcel-addins

Error 0x80042001 when Using VSTO Excel Spreadsheet


I get this HRESULT 0x80042001 error everytime I try to use VSTO to code for Excel Spreadsheet. It will not load. I've tried several things such as uninstall VS and MSO, used cmd to fix issues, troubleshooter ect.

Anyone have this issue or can help me fix it.

I've tried several things such as uninstall VS and MSO, used cmd to fix issues, troubleshooter ect.


Solution

  • Besides repairing VS and MS Office, Make sure the Visual Studio Tools for Office Design-Time Adaptor for Excel is an active Add-in in Excel.

    Also you may find the VisualStudio Excel VSTO Workbook failed with 0x80042001 thread helpful.