To download and install the Team Foundation Server Office Integration 2017, head over to the Visual Studio Downloads page and scroll down to the section labeled Team Foundation Server 2017 Update 2. Install Office 2007 or later on Windows (Sorry no support macOS versions)ĭownload and install the Team Foundation Server Office® Integration 2017Ĭonnect to our TFS instance or VSTS account Non-Developer's Short Guide to Using Excel with TFS/VSTS Work Items For them it's easy to get the Excel features without installing Team Explorer or Visual Studio. However, often there are non-developers on your team who need to work with lots of work items. In those cases, it makes sense to use Excel.įor developers who install Visual Studio, you're good to go.
For example, if you wanted to change a common field on multiple work items, you can select them in the UI (say a few Tasks on the Sprint Backlog, and select Edit: The web interface in TFS and Visual Studio Team Services (VSTS) has become rather amazing, so you won't often need to use Excel. That said, do you still need Excel integration? However, starting with the 2015 release of TFS, Microsoft starting providing an installer package with just the bits you need to make Excel (and God forbid Microsoft Project) work with TFS or VSTS.
#Microsoft team foundation server office integration 2015 how to#
TLDR If you just want the step-by-step on how to work with Excel and work items without installing Team Explorer, jump down to the Non-Developer's Short Guide to Using Excel with TFS/VSTS Work Items on this page.įor years, if you wanted to work with Team Foundation Server (TFS) Work Items from Excel, you had to install the Team Explorer package which basically gave you the Visual Studio Shell plus the extra bits to integrate with Office.