Search code examples
sharepointexceltfsreporting

TFS2010: Opening certain Excel reports gives error TF80076

When I try and open certain TFS2010 Excel reports I get the following error popup from Excel:

TF80076: The data in the work item is not valid or you do not have permissions to modify the data. Please correct the problem and retry.

TF80076

This is then followed by the popup:

TF208103: The initialization of the workbook to connect to Team Foundation Server was not successful. THe workbook will close.... etc. etc..

... and Excel closes.

The reports that throw this error include:

  • Documents -> Samples and Templates -> Project Management -> Document Template - Iteration Backlog.xlsm (in fact all reports in this directory fail)

  • Documents -> Shared Documents -> Iteration 1 -> Issues.xlsx (and all reports in this directory also fail)

I believe that the error may be misleading as this only happens under one project collection and this is a project collection I had some trouble setting up so it was recreated a couple of times. I suspect that the SharePoint site that hosts the reports has got out of sync with the project collection.

Any ideas how to fix these errors?

Is there a way to regenerate the reports that error on the SharePoint site so that they can rebind with the project?

Thanks!

Solution

  • There is also another route to possible success, taken partially from here:

    Open Visual Studio, choose Team -> Team Project Collection Settings -> Process Template Manager. You can download the MSF 5 template to a folder on your hard drive. Then navigate to

    FOLDER YOU DOWNLOADED TO\MSF for Agile Software Development v5.0\Windows SharePoint Services\Shared Documents\Project Management\

    Under this folder you will see the (now connectionless) Iteration Backlog.xlsm.

    Open it & under "Team" choose "New List" & connect it to your Query "Iteration 1" or similar suitable Query.