Integration with Office from Team Explorer stopped working–and how to fix it!

Geeks With Blogs

13 Posts | 101 Comments

BizTalk Server

David Blomqvist

<< New Blank Solution in Visual Studio 2010 | Home | The installer was interrupted before Application could be installed - Installation success or error status: 1603 >>

Integration with Office from Team Explorer stopped working–and how to fix it!

Comments (12) | Share

Last week my office integration from Team Explorer stopped working. the Team menu in excel was gone and when I tried to open a WI-query from VS I got this error message:

TF80012: The document cannot be opened because there is a problem with the installation of the Microsoft Visual Studio v10.0 Team foundation Office integration components. Please see the Team Foundation Installation Guide for more information.

First I tried to fix this by repairing the Team Explorer, this did not fix the problem. The I found a blog post suggesting that re-registration of the Office add-in might solve it. The command is:

For 64-bit windows:
Regsvr32 "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll"

or it you have 32-bit windows:
Regsvr32 "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll"

And this fixed the problem! The menu is back in Excel and i can open queries from VS into office applications.
My environment, for reference: Windows 7 x64, VS 2010, Office 2010 32-bit

Posted on Monday, October 25, 2010 9:31 AM | Back to top

Comments on this post: Integration with Office from Team Explorer stopped working–and how to fix it!

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

And I should also point out that TFS will not work at all with Office 64-bit.You should only use 32-bit office iff you want to use it with TFS.

Left by David Blomqvist on Jan 19, 2011 1:26 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Thank you! Same problem...same fix!

Left by JDonoghue on Mar 09, 2011 6:07 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Cool..this worked

Left by Bob on Mar 21, 2011 5:55 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Thanks.. This worked for me

Left by Anonymous on May 24, 2011 3:48 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

This is very very useful. Thanks so much!!

Left by Betazed on May 24, 2011 11:33 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Thanks! That did the trick for me, too.

Left by Justin Qualler on May 31, 2011 6:26 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Genius. Thanks, I was having exactly the same problem and re-registering the dll fixed it.

Vis Studio 2010, Office 2010, Win XP.

Left by TC on Jul 21, 2011 10:18 PM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

This solution works perfectly. Thanks

Left by Trung on Aug 29, 2011 2:28 PM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

When I try to register the above assembly I get the following error,

"The module "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll" was loaded but the call to DllRegisterServer failed with error code 0x80070005."

Please suggest

Left by Aswani on Oct 10, 2011 5:58 PM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Thanks, we had the same problem and your post helped fix it.

Left by Brian on Nov 23, 2011 5:54 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Just stopped working today - again without any reason at all. Very strange. This did the trick again, no need for a VS restart. Jsut re-register and all is good again.

Left by David on Dec 14, 2011 2:50 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!

Thank you for the post. You have saved the day.

Left by Michael on Mar 28, 2013 11:41 PM

Your comment:

Title:

Name:

Email: (never displayed) (will show your gravatar)

Website:

Comment: Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code

Enter the code shown above

ASP.Net SQL Server Apple Google SharePoint Windows Visual Studio Team Foundation Server Agile Office Design Patterns Web Azure