Geek asks and answers

VSTO Excel Workbook add-in does not load through Visual Studio debugger on the same computer

I have a VSTO Excel workbook project that can be debugged on my laptop. The project solution also accesses some special hardware on another computer, and the project was debugged there yesterday in VS2010. Today, it stopped connecting to Excel when debugging on this computer. F5 starts Excel, but the add-in does not load breakpoints in workbook launch events, etc. The same project from version control debugging works fine on my laptop, so something is hacked on this computer using Excel or VS. Ive seemed to have some related notes / messages about logging into VSTO and resetting Excel, but did someone beat their head against it?

UPDATE: this solution did not work for me. When I was typing, I found this similar and promising name ... Excel will not open / launch VSTO AddIn when running in debug mode of Visual Studio 2010

+5
source share
4 answers

Just check if the add-in is disabled.

Office menu> {Word / Excel / PowerPoint Settings}> In the "Management" section, select "Disabled Items" and click "Go."

For more information read http://blogs.msdn.com/b/vsod/archive/2008/04/22/troubleshooting-com-add-in-load-failures.aspx

/ Artha Wijendra

+5
source

- , ​​ . , "", "", .

Weird!

+4

VSTO. :

  • VSTO HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\AddIns. 32- Office 64- , HKEY_CURRENT_USER\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\AddIns.

  • C:\Users\{username}\AppData\Local\Apps\2.0 (, , .)

  • Excel. "" > "" > "" > " COM" VSTO, .

  • ClickOnce, : rundll32 dfshim CleanOnlineAppCache

If this still does not work, try removing all keys / values ​​from the registry that reference your VSTO and its related assemblies.

+1
source

When my Excel add-in will not load, when I remove the "Start" in Visual Studio for debugging, all I did to fix the problem was "Rebuild" my solution.

0
source

More articles:


All Articles