Accessing TFS. Why Team Explorer and troubleshooting

Here is the big question, how to enable the “Team tab” in Excel without installing the Visual Studio in manager’s computer J, the answer is obvious, installing Team Explorer on his/her computer, but not always is so straightforward, sometimes we have restrictions from IT and we have to look for workarounds.

The list of options is not so big but we have a bunch of clients that can give us access to Team Foundation Server, with more or less capabilities depending what we want to do and the client.

Primary Clients:

Task-specific clients:

Office-Integration clients:

Let’s stop at Office-integration clients for a minute. These add-ins (COM Objects that have to be installed and registered in our OS prior use in Office) supports Office 2007, Office 2010 or Office 2013.
The way to install them is through the Team Explorer standalone installation or with any edition of Visual Studio.

Non-straightforward and dangerous workaround

You can try to do a workaround that is extract the TFSOfficeAdd-in.dll from the Team Explorer ISO and register it manually in the target OS as follows:
regsvr32 TFSOfficeAdd-in.dll

Uninstalling any previous clients (if exists) using the next script:

regsvr32 /u TFSOfficeAdd-in.dll

Also you would need to install the right .NET Framework version required, 2.0, 3.5 or 4.0, depending on the version that you are using.

Note: Make sure that the DLL is available in C:\Windows\System32\

Note: You have to run it as an Administrator, and in some cases depending on the OS, shut down Windows Defender and Windows Firewall.

After this process is finished go to excel and enable the plug-in:

  1. Open Excel
  2. Click File à Options àAdd-ins
  3. Select COM Add-ins

  1. Check the Team Foundation Add-In

This implies to register it as an Excel COM Add-In in the OS, it will require administrative rights and also the installation of .NET Framework as well. Also if they want to uninstall this from the computer further it will be a dirty job. Extra configuration on MS Project and MS Excel will be required as well.

Note: Verify or configure the .NET Programability Support option in the Install or remove individual Office programs and components:

Last step should be to check the registry of Windows we have to make sure that the Entries for Microsoft Office Add-ins are created properly.
For example, for Excel you would find them here:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\

You can find extra information about the needed keys here: http://msdn.microsoft.com/en-us/library/vstudio/bb386106(v=vs.90).aspx

Note: This steps can be used as well for troubleshooting in case the Team Explorer repair option doesn’t work.

My recommended choice for a non-invasive installation is to install Team Explorer as a standalone installation.

Why Team Explorer?

Team Explorer is the client software that you use to access the Team Foundation Server functionality. And we can think that it is only to extend Visual Studio in order to connect to Team Foundation Server but it is not the case.

Team Explorer has side-by-side compatibility of Team Foundation clients. You can run Team Explorer with:

  • Microsoft Test Manager
  • Microsoft Project
  • Microsoft Excel
  • PowerPoint Storyboarding.

Even exists a MS Word non official Add-in provided by the Visual Studio ALM Rangers and published in Codeplex here.

How it works?

In MS Project the process is the same:

What can you do with this Team options?

For example, using Excel you can add or modify work items with Excel as well update reports. More info here.

Using MS Project, you can create your backlog and tasks, publishing and refreshing your work items, timelines, resources usage, etc. More info here.

Using PowerPoint, you can turn your ideas and goals for your PBIs in something more visual. Storyboarding is part of the PBI in TFS2012 and TFS2013. More info here.

So here is the main ask for you, how far do you want to go?

As depending on the client that you are using the possibilities will be extended or reduced. It’s not part of this blog post to cover one by one all the features accessible through the TWA, Team Explorer and Office, for that just access to this link and check the Tasks and client support tables, but summarizing what you can do with these clients here a short list:

  • Manage source code and builds
  • Plan a project, track progress
  • Bulk add and modify work items
  • Add and modify work item links
  • Collaborate with team members and stakeholders
  • Happy planning! –

Eduardo Ortega

Links of interest:

Compatibility between Team Foundation clients and Team Foundation Server: http://msdn.microsoft.com/en-us/library/dd997788.aspx
Choose the Team Foundation client to support your tasks: http://msdn.microsoft.com/en-us/library/ms181304.aspx
Connect Microsoft Excel or Microsoft Project to a team project: http://msdn.microsoft.com/en-us/library/ms181675.aspx
Microsoft Project and Microsoft Excel Integration Architecture: http://msdn.microsoft.com/en-us/library/ms181661%28VS.90%29.aspx
Working with Team Foundation Clients: http://msdn.microsoft.com/en-us/library/ms181304(v=vs.100).aspx
Managing Work Using Team Web Access: http://msdn.microsoft.com/en-us/library/ee523998(v=vs.100).aspx
Bulk add or modify work items with Excel: http://msdn.microsoft.com/en-us/library/dd286627.aspx
Work in Limited access view or Work Item Only View: http://msdn.microsoft.com/en-us/library/cc668124.aspx
Work in Team Explorer: http://msdn.microsoft.com/en-us/library/hh500420.aspx

Downloads:

Microsoft Visual Studio Team Explorer Everywhere 2010 with SP1: http://www.microsoft.com/en-us/download/details.aspx?id=25125

Microsoft Team Explorer Everywhere 2013: http://www.microsoft.com/en-us/download/details.aspx?id=40785
Visual Studio Team System 2005 Team Explorer: http://www.microsoft.com/en-us/download/details.aspx?id=7203

Microsoft Visual Studio Team Explorer 2010 – ISO: http://www.microsoft.com/en-us/download/details.aspx?id=329

Team Explorer for Microsoft Visual Studio 2012: http://www.microsoft.com/en-us/download/details.aspx?id=30656
Team Explorer for Microsoft Visual Studio 2013: http://www.microsoft.com/en-us/download/details.aspx?id=40776

Advertisements
Categories: TFS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s