The Case Of The Missing TFS Office Add-In

This week my Team Toolbar Office add-in for Team Explorer disappeared preventing me from uploading any new Work items to Team Foundation Server. After some searching in Excel (and MS Project) I accepted it wasn’t just hiding and turned to Google for help. Luckily I found this helpful post on the Team Foundation Server Team’s MSDN blog:

In summary it tells you where on your machine the TFS Office Add-in is located for VS 2010 and VS 2008, e.g: “Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll” or “Program Files\Microsoft Visual Studio 9\Common7\IDE\PrivateAssemblies\TFSOfficeAdd-in.dll”, and reminds you how to register/unregister these COM components, (i.e. regsvr32(/u) TFSOfficeAdd-in.dll).

I unregistered the VS 2010 add-in and registered the VS 2008 one (as I needed the 2008 based add-in) and “hey presto”, the Team Toolbar was back in Excel.