Team Services | TFS 2017 | TFS 2015 | TFS 2013
If you don't see the Team ribbon in Excel, as shown in the image below, you may be able to resolve the issue with the procedures provided in this topic.
Enable the Team Foundation Add-in
- From the Excel File menu, choose Options.
Choose Add-ins and from the Manage pick list, choose COM Add-ins, and then choose Go.
Make sure that a check is placed in the Team Foundation Add-in checkbox.
Restart Excel. You should now see the Team ribbon.
If the Team ribbon does not appear at next launch, the load behavior of the add-in may have changed and you will need to complete the following steps:
Update the Registry
Launch the Registry Editor from your Windows Start Menu by typing regedit in the Search or Run box.
Navigate to one of the following paths containing the TFCOfficeShim.Connect.[version] folder:
If there are multiple folders with the same name, select the one with the highest version number.
- HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins (if this key does not exist, try one of the options below)
Double click to open LoadBehavior and set the value data field to 3 (if the value is 0, the Team ribbon will not load).
Press OK and restart Excel.
To learn more about the LoadBehavior entry, see Registry Entries for VSTO Add-ins, LoadBehavior values.
Office Add-in doesn't load or “Open in Excel” from Visual Studio fails
To connect to TFS, go to the Team ribbon and choose New List. If the New List dialog fails to open, or you receive TF86001 or similar error message, follow the steps below to ensure that policy redirection is configured.
This error is typically caused when you install Visual Studio before you install Office Excel or Project. In this instance, the Visual Studio Tools for Office Run Time are not correctly configured. To correct this error, you must repair Visual Studio.
Install Visual Studio to ensure that you have access to the Visual Studio Command Prompt and the Gacutil.exe (Global Assembly Cache Tool). If you do not have Visual Studio, you can install the Visual Studio Community edition for free.
Run the Gacutil tool
Open the Visual Studio Command Prompt and choose to run it as an administrator.
For Office 2016 and Office 2013, run the following commands:
GACUTIL /I C:\Windows\assembly\GAC_MSIL\Policy.12.0.Microsoft.Office.Interop.Excel\184.108.40.206__71e9bce111e9429c\Policy.12.0.Microsoft.Office.Interop.Excel.dll
GACUTIL /I C:\Windows\assembly\GAC_MSIL\Policy.12.0.office\220.127.116.11__71e9bce111e9429c\Policy.12.0.Office.dll
For Office 2010, run the following commands:
GACUTIL /I C:\Windows\assembly\GAC_MSIL\Policy.12.0.Microsoft.Office.Interop.Excel\18.104.22.168__71e9bce111e9429c\Policy.12.0.Microsoft.Office.Interop.Excel.dll
GACUTIL /I C:\Windows\assembly\GAC_MSIL\Policy.12.0.office\22.214.171.124__71e9bce111e9429c\Policy.12.0.Office.dll
- Once you've successfully run the
GACUTILcommands, restart Excel and look for the Team Foundation Add-in.
If the above steps are unsuccessful, try the following steps:
- Perform a full repair of Office.
- Uninstall Office and Reinstall Office.
- Contact the Microsoft support team.