VS2010: Error when creating Excel 2010 Template or Excel 2010 Workbook

Question

Hi there!

When I try to create Excel 2010 Template or Workbook, VS2010 show the following error message:

Project cannot be created because the "Excel Visual Studio Design-Time Adaptor Add-In" is not working correctly. Excel might have disabled the add-in or made it inactive, or all add-ins might be disabled in your Trust Center settings. Check the add-in status in Excel Options. If the add-in is active and enabled, reinstall or repair  Visual Studio Tools for Office.

Add-ins are enable in my Excel 2010. I've already repaired VS and Office and nothing changes.

Any suggestion to fix this bug?

Best regards,

---

Ciro

Answer 1

Additional information:

In another computer (VS2008 with Excel 2007), Excel's Add-In COM list shows the following Add-Ins available:

- Microsoft Visual Studio 2008 Tools for Office Design-Time Adaptor for Excel 2003

- Microsoft Visual Studio 2008 Tools for Office Design-Time Adaptor for Excel 2007

In my development computer (VS2010 with Excel 2010) I don't see anything like the add-in above.

Any suggestion?

Best regards,

---

Ciro

Answer 2

Hi Ciro,

Thanks for posting in the MSDN forum.

It's based on my experience that you need reinstall VSTO runtime for you development machine.

Have a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi, Tom! Thanks to reply!

Unfortunately, your suggestion didn' work.

Any other suggestion?

Best regards,

---

Ciro

Answer 4

Before I install Office 2010, I uninstalled Office 2007. Maybe the uninstaller let some trash in Windows registry, isn't it?

Is there a way to clean Windows Registry after uninstall Office 2007?

best regards,

---

Ciro

Answer 5

Hi, Tom!

I removed Visual Studio 2010 SP1 and Visual Studio 2010 from my computer, and reinstalled both of then.

Now, when I try to create VSTO projects (Excel Template or Excel Workbook ), I got the following erro message (for Excel Add-Ins, VS2010 works nice):

This registry key refers to (MS Office 2010 is installed in my computer):

Any suggestion to fix this?

Many thanks for any kind of help.

Best regards,

Ciro.

---

Ciro

Answer 6

I got the solution:

1- Uninstall VS2010 SP1

2- Uninstall VS 2010

3- Run VS 2010 Uninstall Utility (complete: /full /netfx).

4- Install VS 2010

5- Install VS 2010 SP1

I hope these tips help others developers.

Best regards,

---

Ciro