Last week i encountered a strange error. While trying to publish some items to TFS using Excel's TFS add-in, i had some network connectivity issues and post that error, whenever i tried to launch TFS query results to Excel using "Open in Microsoft Excel" option, i started to see following prompt.
TF80012: The document cannot be opened because there is a problem with the installation of the Microsoft Visual Studio Team Foundation Office integration components. For more information, see the following page on the Microsoft website: http://go.microsoft.com/fwlink/?LinkId=220459.
When i visited the URL mentioned in the prompt, i did not find anything that made sense to me. It was strange because everything was working smoothly prior to the publishing failure caused by network connectivity issues. In the end, the solution to this problem was pretty simple.
Somehow, the COM add-in in Excel for TFS 2012 was disabled - maybe Excel found the last error caused by the add-in to be severe or something. When i opened a new Excel workbook, TEAM option was not showing up. All i needed to do was:
1. Open new Excel and select Options from File menu.
2. In the popup window, select Add-Ins, select "COM Add-In" in the "Manage" dropdown at the bottom of the popup window and press Go.
3. In the new popup window, select "Team Foundation Add-in" and press OK.
And everything is back to normal.
TF80012: The document cannot be opened because there is a problem with the installation of the Microsoft Visual Studio Team Foundation Office integration components. For more information, see the following page on the Microsoft website: http://go.microsoft.com/fwlink/?LinkId=220459.
When i visited the URL mentioned in the prompt, i did not find anything that made sense to me. It was strange because everything was working smoothly prior to the publishing failure caused by network connectivity issues. In the end, the solution to this problem was pretty simple.
Somehow, the COM add-in in Excel for TFS 2012 was disabled - maybe Excel found the last error caused by the add-in to be severe or something. When i opened a new Excel workbook, TEAM option was not showing up. All i needed to do was:
1. Open new Excel and select Options from File menu.
2. In the popup window, select Add-Ins, select "COM Add-In" in the "Manage" dropdown at the bottom of the popup window and press Go.
3. In the new popup window, select "Team Foundation Add-in" and press OK.
And everything is back to normal.
Great, this solved my issue, searched through MS articles but did not helped. Thanks!!
ReplyDelete