TFS2010：打开某些Excel报告给出错误TF80076 [英] TFS2010: Opening certain Excel reports gives error TF80076

问题描述

当我尝试打开某些TFS2010 Excel报表时，我从Excel中收到以下错误弹出窗口：

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

TF80076：工作中的数据项目是
无效或您没有
权限修改数据。请
纠正问题并重试。

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.

然后是弹出窗口：

TF208103：
工作簿的初始化连接到Team Foundation
服务器不成功。
工作簿将关闭....等等。

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

...和Excel关闭。

... and Excel closes.

抛出此错误的报告包括：

The reports that throw this error include:

• 文档 - >样本和模板 - >
  项目管理 - >文档
  模板 - 迭代Backlog.xlsm （在
  中，所有报告在此目录中
  失败）

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

文档 - >共享文档 - >
迭代1 - > Issues.xlsx （和所有
报告在此目录也失败）

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

我认为错误可能会产生误导，因为这只会在一个项目集合下发生，一个项目集合我设置了一些麻烦，所以重新创建了几次。我怀疑托管报告的SharePoint网站与项目集合不一致。

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.

有什么想法来解决这些错误？

有没有办法在SharePoint网站上重新生成报告错误，以便他们可以使用项目重新绑定？

谢谢！

推荐答案

还有另一条可能的成功路线， a href =http://social.msdn.microsoft.com/Forums/en-US/tfsprocess/thread/c449ba9a-f618-46c9-9365-d36ee4bc9a88/ =nofollow> here ：

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

打开Visual Studio，选择Team - > Team Project Collection设置 - > Process Template Manager。您可以将MSF 5模板下载到硬盘驱动器上的文件夹。然后导航到

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

您下载的文件夹为敏捷软件开发v5.0 \Windows SharePoint Services \共享文档\Project Management \

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

在此文件夹下，您将看到（现在无连接）迭代Backlog.xlsm。

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

打开它&在团队下选择新名单&将其连接到您的查询迭代1或类似的相似查询。

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

这篇关于TFS2010：打开某些Excel报告给出错误TF80076的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！