Tuesday, June 16, 2009 3:14 AM
Once you have imported a list of work items in excel from a team project in TFS, the excel file always proposes work items from the same team project. It does not seem possible to obtain the "connect to TFS" popup window again, where you choose the team project. This is because the connection is stored as a custom property in the excel file.
The answer is to delete all custom properties from the file. Go to the main menu and then: Prepare / Properties / Document Properties / Advanced Properties / Custom. Delete all "VS Team System Data DO NOT EDIT" properties (the content is encrypted). Do NOT save the file. If you save it, the properties are created again! Just go to the Team menu and choose "New List": you will now be prompted to choose a team project.
If you need to save the file (you want to keep it without the TFS connection in it), follow the instruction given by Buck Hodges here. Before removing the properites, you have to deactivate the TFS excel add-in.