We frequently use Excel to perform bulk updates of data in TFS. Up until very recently, the Team Foundation Add-In has worked very well. However, it has started failing in several ways:
It will connect to the server, but attempting to connect to any project causes Excel to crash, producing a Watson report in the Windows Application Event Log.
If I restart Excel, it reports that it is running into problems with both the shim and the add-in, and offers to disable it. If I do not disable it, I still can't connect to a project.
Eventually, the add-in refuses to load at all, until I use the Options dialog to manually add the COM add-in back into the application. Doing so produces the same results (Excel crashes when attempting to load a project).
I have taken the following steps in an attempt to resolve the issue:
None of these have produced a fix to the issue.
Does anyone know how to resolve this issue?
P.S. If this is not the correct "stack" for this question, kindly point me to the correct one on the exchange. Thank you.
In general cleaning the caches on your client machine will resolve such problems, including the TFS and VS caches...
To clean the caches, please see How to clear the TFS cache on client machines