Team tab is removed every time Excel 2010 is opened

Question

Using Excel 2010 and TFS 2010. I've been using the "Team" tab in Excel for quite a while now (very useful!). Today, the "Refresh" took ages and I couldn't use Excel so I killed the process in Task Manager. I reopened Excel and the Team tab was missing. I added it back in File > Options > Add Ins > Manage COM Add Ins > Go > selected the Team Foundation Add-In and the Team tab is back. I can create/view lists etc. However, when I close and reopen Excel the Team tab is missing again.

How do I make the Team tab stay on the ribbon bar even when closing & reopening Excel?

Answer 1

For Excel 2013 x64 and Visual Studio 2012, I had to change HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\TFCOfficeShim.Connect.4\LoadBehavior to 3 (Load at startup).

I had previously disabled the add-in via the Excel COM Add-Ins dialog box. This changed the add-in load behavior to "do not load automatically". Attempting to re-enable the add-in through the dialog box now only changes it to "load on demand", which is only good for one session of Excel. There is an issue logged in Connect for this. Changing the registry manually works around the bug.