Search code examples
excelvstoexcel-addins

Excel 2007 VSTO Add-in Not visible even after successful install

I am bit confused with the excel 2007 addin behaviour. Any ideas is highly appreciated. Here is what I am doing in chronological order.

  1. I have a excel 2007 VSTO addin and it build and debugs file so I Publish it to a folder
  2. I go to the folder and run the Setup which installs the addin . Next time when I open excel the addin is visiable. So far perfect !!
  3. Then I go to Excel Office button -->Excel Options -->Addins --> Manage --> COM Addins and remove the addin that I just installed. This makes the addin go away from my excel ribbon. So far as expected !!

But at this point my addin is installed and is only removed from the list of active addins. Correct ? If it is correct how do I re-add it , because I cannot see it in list of inactive addins. The only way I get it back is to remove it from Add/Remove Programs and reinstall and restart excel.

Is this is only way or I can re-add the addin somehow since it is already installed.

Solution

  • As far as I know, that's a problem with VSTO. With normal COM addins, you can open the Com Addin window, click the ADD button and select your addin's dll.

    But with VSTO, that doesn't work, since VSTO dll's are not quite "normal" COM dlls. For VSTO, you have to point Excel at the .VSTO file, but you can't do that from within Excel itself, only an installer can make that happen.