Random Musings

August 29, 2009

Error TF86001 or TF80042 Opening Microsoft Team Foundation Server Work Items in Microsoft Excel or Microsoft Project

Filed under: TFS — haditeo @ 8:06 am

While performing walkthrough for managing work items in Excel and Project here, apparently Excel and Project was not installed. So Excel and Project are installed after Team Foundation Server.

When opening Excel or Project document, this error is reported “TF80042: The document cannot be opened because you do not have Microsoft Excel 200n or one of its components installed.” So to resolve this issue, Excel and Project should be installed. In this case, i install the 2003 version

After Excel and Project 2003 are installed, another error is reported “TF86001: Team Foundation was unable to load the Office Add-In.”. So i googled around and find out this KB Article

The core solution is to repair the Visual Studio 2005/2008 Team Explorer, so that the installation can “link” back the Excel / Project to the Team Explorer


Blog at WordPress.com.