How to connect MS office to TFS. I don't see the addin's

Question

I am trying use the mass-update feature from projects and excel. The add-in doesn't have Team addin to enable in MS excel. I have access to TFS though.

Solution

If you just want to enable the add-in in Excel, then you need to install Visual Studio or at least install the Team Explorer. Generally the add-in will automatically enabled. If you still cannot see the Team ribbon, you can refer to below article for troubleshooting: TFS-Office integration issues

In your scenario, you can use the TFS Office Integration Installer. This new installer just includes the Office integration component (Excel, Project, etc) and is therefore lighter weight. See this blog : TFS Office Integration Installer

For 2017 version : Team Foundation Server Office Integration 2017 (version 15.3)

Note that support for integrating TFS with Project Server is deprecated for TFS 2017. However, synchronization support is provided by a third part. See Synchronize TFS with Project Server for details.

Source here : Office integration tools