TFS2010: Opening certain Excel reports gives error TF80076

Question

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.

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!

Answer 1

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.

Answer 2

I also come across same issue. After trying following changes it started working.
Check from edit query in Azur if your query using variable like "@RecentProjectActivity" then replace it with other possible static references like you can refer some Area Path or any ID. Hope it will resolve your issue. Thank you.