none
Excel integration error TF80070 with TFS 2008

    Question

  • This seems like a similar problem to:

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164646&SiteID=1

    which didn't ever seem to get resolved.

     

    We have a user who is trying to export work items to Excel from TFS2008 team explorer. They are running Team Explorer via Citrix, to export work items to Excel 2003. They select the workitems in Visual Studio, and when they click the toolbar button get an error:

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

     

    I have tried to recreate, but the problem does not occur under my logon. The problem has only started to occur this week (we installed TFS2008 a few weeks ago, but this user was not using 2008 until a week or two ago.)

    The Citrix server has Team Explorer 2005 and 2008 installed, but no other Visual Studio installations (no C#, VB.NET etc.)

     

    Any advice? Any way to clear this error?

     

    Dylan.

     

     

    Tuesday, March 18, 2008 5:24 AM

Answers

  • Few questions

    1) Do you see this error in both Team Explorer 2005 and 2008 (while exporting to Excel)?

    2) What happens if you launch Excel and then use "Team-->New List" to insert a new TFS bound list and then import workitems using "Team-->Get WorkItems"?

    3) Also can you enable tracing using the settings at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1893161&SiteID=1  (search for system.diagnostics) and post the log file contents

    Tuesday, March 18, 2008 5:56 PM
  • TF80012 error on exporting from TFS 2005 is a known side-by-side issue with TFS 2005 and TFS 2008 installed. You can contact Microsoft Product support to get a fix for this. See http://support.microsoft.com/kb/946075/en-us for more details on this and how to get the fix.

     

    Hope this helps.

     

    Wednesday, March 19, 2008 4:43 AM

All replies

  • Few questions

    1) Do you see this error in both Team Explorer 2005 and 2008 (while exporting to Excel)?

    2) What happens if you launch Excel and then use "Team-->New List" to insert a new TFS bound list and then import workitems using "Team-->Get WorkItems"?

    3) Also can you enable tracing using the settings at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1893161&SiteID=1  (search for system.diagnostics) and post the log file contents

    Tuesday, March 18, 2008 5:56 PM
  • Thanks Swamy,

     

    1) I get a different error in 2005:

    TF80012: The document cannot be opened because there is a problem with the installation of the Visual Studio 2005 Team Foundation Office integration components...

    and it doesn't even launch Excel.

     

    In 2008 I get the TF80070 message and it launches Excel but doesn't populate it at all.

     

    2) Importing items directly into Excel seems to work fine.

     

    3) Once I turned logging on, the problem disappeared in TFS2008. The log file is full of valid stuff, I won't bother posting it, as there is nothing abnormal and it is pretty big. Suddenly 2008 is working again. Turned off logging and it still works.

    With or without logging, TFS2005 is still broken. I am still getting the TF80012 message in 2005.

     

    If I start getting the error with 2008 again, I will switch on logging again and post the log.

     

     

    Wednesday, March 19, 2008 3:52 AM
  • TF80012 error on exporting from TFS 2005 is a known side-by-side issue with TFS 2005 and TFS 2008 installed. You can contact Microsoft Product support to get a fix for this. See http://support.microsoft.com/kb/946075/en-us for more details on this and how to get the fix.

     

    Hope this helps.

     

    Wednesday, March 19, 2008 4:43 AM
  • The support article KB946075 describes the issue quite accurately, but considering you cannot download the hotfix at the time of this writing, it isn't going to help you much (unless you have MS support calls available to you at your organization).  I found that while I can't export from VS08, I can from VS05 (which will connect to TFS 2008), so until you can get your hands on the hotfix, try exporting from VS05.

     

    Wednesday, June 18, 2008 1:09 PM
  • I was getting this error when opening work items through Visual Studio 2008, but then I tried it through 2005. At first 2005 wasn't configured to connect to TFS, but once I configured it, it connected and opened the work items.

    After that, opening work items from 2008 works as well. Our TFS server is 2005 so it seems that my 2005 client had to be configured for 2008 to work as well.

    My colleague could open them from 2008 without any problems from the beginning but he doesn't have 2005 Team Explorer on his machine. Definately looks like a 2005/2008 side-by-side problem.
    Tuesday, March 17, 2009 4:43 PM
  • Go to the "Team" tab of the excel, click new list. connect to your team foundation server. run any query you want and close the excel

    now go back to your team explorer in the TFS and export any query to excel you want, it will work fine

    what happens in the back ground is, it give a kick to excel on the back side that makes it work

     


    Irfan
    Thursday, August 12, 2010 4:07 AM