Geeks With Blogs
David Blomqvist

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:

clip_image002

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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
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!
Requesting Gravatar...
Thank you for the post. You have saved the day.
Left by Michael on Mar 28, 2013 11:41 PM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!
Requesting Gravatar...
Thanks for the tip. Came at the most opportune time.
Left by Arun T on Apr 08, 2014 6:18 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!
Requesting Gravatar...
I get the same error as Aswani when trying to re-register TFSOfficeAdd-in.dll:

"The Module "TFSOfficeAdd-in.dll" was loaded but the call to DllRegisterServer failed with error code 0x8007005."

It used to work, maybe it's because I recently installed Visio? Or because I used to run Visual Studio as Administrator, but stopped doing that because it actually creates more problems than it fixes?

Anyhow, I'm still able to use TFS from Excel by going to Team > New List in Excel, but it's really not as convenient as opening the query from Visual Studio.
Left by Joost Molenaar on Jul 08, 2014 2:06 AM

# re: Integration with Office from Team Explorer stopped working–and how to fix it!
Requesting Gravatar...
Very helpful! Thank you very much!
Left by Victor on Jan 24, 2015 7:03 AM

Your comment:
 (will show your gravatar)


Copyright © blomqvist | Powered by: GeeksWithBlogs.net