TFS 2010 and Excel Integration issues– TF80070 error

If you have ever run into the

TF80070: Team Foundation encountered an error while performing the operation. It is recommended that you save your work and restart the application.

that is talked about on MSDN – the likely solution can be found below – it has resolved the issue for multiple people that have had to deal with this issue!

________________________________________________________________________________________

This fix was found at the following URL – http://www.mail-archive.com/oztfs@oztfs.com/msg00714.html

Copy the following contents to a config file and name it as
Excel.Exe.Config (for TFS Excel Add-In) or WinProj.exe.config (for TFS
Project Add-in)

<?xml version="1.0"?>
<
configuration
>
  <
startup useLegacyV2RuntimeActivationPolicy="true"
>
    <
supportedRuntime version="v4.0"
/>
  </
startup>

  <system.diagnostics
>
    <
switches
>
      <
add name="General" value="4"
/>
    </
switches
>
    <
trace autoflush="true" indentsize="4"
/>
  </
system.diagnostics
>
</
configuration
>

  2.       Copy this config file to the folder where Excel.exe/WinProj.exe
is installed (typically this will be Program Files\Microsoft Office\Office11
or Program Files\Microsoft Office\Office12) . On Vista if UAC is turned on
then you won’t be able to save a file under Program Files. So save this file
under some other folder (say %temp%) and copy this file to Office install
directory under Program Files

3.       Close and re-launch Excel or WinProj

4.       Re-try your scenario. If it doesn’t work Excel trace information will be added
to %temp%\tfs_msexcel.log and for MSProject it will added to
%temp%\tfs_msproject.log

Advertisements
This entry was posted in Technology. Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s