Close an Excel spreadsheet with/or without having a TFS/VSTS connected list. When you open the spreadsheet again, the Team tab is missing in the ribbon bar.
You then need to go through and re-enable the plugin through Excel options to reload the plugin and get the Team tab back.
This also disconnects your TFS/VSTS linked worksheets, causing you to have to reconnect or re-open a query to carry on working with the work items.
- With Excel closed, open up the registry editor (regedit)
- Then navigate to HKEY_CURRENT_USERSoftwareMicrosoftOfficeExcelAddins , and find the TFCOfficeShim entries:
There may be more than one, and the version number at the end may differ to the image above
- I simply remove/delete the “older versions” (I surely do not have to remind you to take a backup of your registry before you make any changes),
- and then find the “LoadBehavior” in the “folder” and make sure that the value is 3
Now re-open the spreadsheet and see if it will load automatically.