Geeks With Blogs
Clara's Notes on Technology Notes to me and the world

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.

Posted on Tuesday, June 16, 2009 3:14 AM Team System | Back to top


Comments on this post: Change Excel connection to a team project

# re: Change Excel connection to a team project
Requesting Gravatar...
Thank you so much! Very helpful post!
Left by Ana Eva López on Feb 10, 2010 9:29 AM

# re: Change Excel connection to a team project
Requesting Gravatar...
Awesome , i am able to resolve using above steps.

thanks
Left by SKL on Aug 05, 2010 2:23 PM

# re: Change Excel connection to a team project
Requesting Gravatar...
Thanks! I've been trying to do this for a long time. I use Excel to make burndown charts and switching projects is a pain. Great help!
Left by Tom Hall on Jan 04, 2011 5:16 PM

# re: Change Excel connection to a team project
Requesting Gravatar...
Great solution - exactly what I needed!
Why do Microsoft make it so hard to achieve an obviously required thing?
Left by Chris on Jul 27, 2011 4:50 PM

# re: Change Excel connection to a team project
Requesting Gravatar...
Brilliant thanks, very useful
Left by Jay on Dec 17, 2014 1:42 PM

# re: Change Excel connection to a team project
Requesting Gravatar...
I am unable to find

Go to the main menu and then: Prepare / Properties /

Please guide more where I can find prepare option?
Left by ali on Sep 18, 2015 1:04 PM

Your comment:
 (will show your gravatar)


Copyright © Clara Oscura | Powered by: GeeksWithBlogs.net