Hi experts,
I’m working with TFS2012, and when I want to export a user story to excel I get the following dialog box.
I really need your help to resolve this error so that I can proceed.
Thanks in advance.
Microsoft Visual Studio
Team Foundation Error
TF400422: Failed to open in Microsoft Excel: Error loading type library/Dll.
(Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
Hi David,
You may want to try to re-register your Office add-in you can follow this command:
For 64 bit windows:
Regsvr32 “C:Program Files (x86)Microsoft Visual Studio 10.0Common7 IDE PrivateAssemblies TFSOfficeAdd-in.dll”
For 32 bit Windows:
Regsvr32 “C:Program FilesMicrosoft Visual Studio 10.0Common7 IDE PrivateAssemblies TFSOfficeAdd-in.dll”
This should resolve your issue, however some would suggest that this add in often fails on a 64 bit platform so using 32 bit software would be the best way to go.
The problem lies in team foundation server. You need the team foundation server to restart. Just restart the team foundation server and check for the error. I feel the error will be gone.
Waters Magner
This error appears because the TFS add-in does not work with 64bit versions of MS Office.
A way to try to avoid this error is to use the TEAM tab to connect to the TFS add-in from Excel and subsequently use the TFS Query option to create a new list.
