Disassociating MPP or a XLS(X) from a TFS Team Project

TFS 2010 provides an intuitive association between a MS Project Plan (MPP) or an Excel workbook with a TFS Team Project.

But this UI intuitiveness is totally absent while trying to disassociate the same. In fact, i’am pretty confident that MS never meant to have a dis-associate feature in the first.

However, Thanks to the following two blogs, there is a way to disassociate a MPP/Excel from a TFS team project.

http://blogs.msdn.com/b/buckh/archive/2006/07/19/remove-tfs-project-excel.aspx

http://social.msdn.microsoft.com/forums/en-US/tfsgeneral/thread/73b37693-9cb7-45c5-bb2a-6f90bb329948

While the above two blogs have steps of their own, i would like to document the steps that one of our pilot projects had followed for a successful disassociation of a MPP from TFS.

  1. Open your project from Project server
  2. Choose Properties from the File menu
  3. Choose the Custom tab in the Properties window.
  4. Choose any Property listed there named “VS  Team System Data Do Not Edit” and click Remove.
  5. Click Apply or Ok.
  6. Close MS Project
  7. Re-open your project from Project server and it is now unassociated from TFS.

The above mentioned blogs do talk about disabling the TFS Add-in by going to HKLM\Software\Microsoft\Office\Excel\Addins\TfcOfficeShim.Connect and change the ‘LoadBehavior’ from ‘3’ to ‘0’. This wasn’t necessary in our case.

To disassociate an Excel workbook from TFS Team Project, the following steps will have to be followed.

  1. Close Excel.
  2. Disable the TFS addin by going to HKLM\Software\Microsoft\Office\Excel\Addins\TfcOfficeShim.Connect and change the ‘LoadBehavior’ from ‘3’ to ‘0’.
  3. Open the .xls file.
  4. Wipe out the contents of the custom document properties (File -> Properties -> Custom).
  5. Save the file and exit Excel.
  6. Re-enable the TFS addin.

Note: I need the validate the steps provided for the Excel disassociation, will update you with the same very soon.

Advertisements

One thought on “Disassociating MPP or a XLS(X) from a TFS Team Project

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s