{"id":3833,"date":"2006-07-19T22:45:00","date_gmt":"2006-07-19T22:45:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/buckh\/2006\/07\/19\/removing-the-team-foundation-server-association-in-microsoft-project-and-microsoft-excel-files\/"},"modified":"2006-07-19T22:45:00","modified_gmt":"2006-07-19T22:45:00","slug":"removing-the-team-foundation-server-association-in-microsoft-project-and-microsoft-excel-files","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/buckh\/removing-the-team-foundation-server-association-in-microsoft-project-and-microsoft-excel-files\/","title":{"rendered":"Removing the Team Foundation Server association in Microsoft Project and Microsoft Excel files"},"content":{"rendered":"

Here’s a handy tip if you find yourself needing to disassociate or unbind a Microsoft Project (.mpp) or Microsoft Excel (.xls) file from a Team Foundation Server, perhaps because you changed the name of the server, the server no longer exists, etc.<\/p>\n

Microsoft Project<\/strong><\/p>\n

Yogita Manghnani, a PM for TFS, posted the following process<\/a> in the Team Foundation Server MSDN forum<\/a>.<\/p>\n

    \n
  1. Close Microsoft Project \n<\/li>\n
  2. Right click on the mpp file and choose Properties. \n<\/li>\n
  3. Choose the Custom tab in the Properties window. \n<\/li>\n
  4. Choose any Property listed there named “VS  Team System Data Do Not Edit” and click Remove. \n<\/li>\n
  5. Click Apply or Ok. \n<\/li>\n
  6. Open the mpp file, and you will get a message saying its not associated with any TFS server. Click Ok and Save it. \n<\/li>\n
  7. You will not get the error message every time you open the mpp file as long as you save it once after the message is received.<\/li>\n<\/ol>\n

    Microsoft Excel<\/strong><\/p>\n

    Dennis Habib, a developer for TFS, provides the following process.  Since this involves editing the registry, all of the usual caveats apply.<\/p>\n

      \n
    1. Close Excel.<\/li>\n
    2. Disable the TFS addin by going to HKLMSoftwareMicrosoftOfficeExcelAddinsTfcOfficeShim.Connect and change the ‘LoadBehavior’ from ‘3’ to ‘0’.<\/li>\n
    3. Open the .xls file.<\/li>\n
    4. Wipe out the contents of the custom document properties (File -> Properties -> Custom).<\/li>\n
    5. Save the file and exit Excel.<\/li>\n
    6. Re-enable the TFS addin.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Here’s a handy tip if you find yourself needing to disassociate or unbind a Microsoft Project (.mpp) or Microsoft Excel (.xls) file from a Team Foundation Server, perhaps because you changed the name of the server, the server no longer exists, etc. Microsoft Project Yogita Manghnani, a PM for TFS, posted the following process in the Team […]<\/p>\n","protected":false},"author":94,"featured_media":10268,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[8],"class_list":["post-3833","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-team-foundation"],"acf":[],"blog_post_summary":"

      Here’s a handy tip if you find yourself needing to disassociate or unbind a Microsoft Project (.mpp) or Microsoft Excel (.xls) file from a Team Foundation Server, perhaps because you changed the name of the server, the server no longer exists, etc. Microsoft Project Yogita Manghnani, a PM for TFS, posted the following process in the Team […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/3833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/users\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/comments?post=3833"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/posts\/3833\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media\/10268"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/media?parent=3833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/categories?post=3833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/buckh\/wp-json\/wp\/v2\/tags?post=3833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}