TFS2010：打开某些 Excel 报告会出现错误 TF80076
当我尝试打开某些 TFS2010 Excel 报告时，我从 Excel 中收到以下错误弹出窗口：
TF80076：工作项中的数据是 无效或您没有 修改数据的权限。请 纠正问题并重试。
然后弹出窗口：
TF208103：初始化 连接到 Team Foundation 的工作簿 服务器未成功。这 工作簿将关闭...等等等等..
...并且 Excel 将关闭。
引发此错误的报告包括：
文档 ->样本和模板 -> 项目管理->文档 模板 - 迭代积压.xlsm（在 事实上该目录中的所有报告 失败）
文档 ->共享文档-> 迭代 1 -> Issues.xlsx（以及所有 此目录中的报告也会失败）
我相信该错误可能会产生误导，因为这只发生在一个项目集合下，而这是一个我在设置时遇到一些问题的项目集合，因此它被重新创建了几次。我怀疑托管报告的 SharePoint 网站与项目集合不同步。
有什么想法可以修复这些错误吗？
有没有办法重新生成 SharePoint 网站上出现错误的报告，以便它们可以与项目重新绑定？
谢谢！
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!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
生成团队项目时，还会生成这些 Excel 工作表，指向“迭代 1”迭代（可在右键单击“团队项目”，然后“团队项目设置”>“区域和迭代...”找到）和“迭代 1”迭代。还指工作项目 - 团队查询“迭代 1\迭代待办事项”。
如果您设法编辑/删除这两个，Excel 功能将被破坏。尝试恢复那些回来& Excel 将再次工作。然后转到 Excel 功能区“团队”并选择“配置\列表”&设置有效的查询，指向团队项目中的有效迭代。
您现在可以删除查询以及团队项目迭代。
我在此处找到了此分辨率 - （德语）&这是一个救星
At the time the Team Project is generated those Excel sheets are also generated, pointing to "Iteration 1" Iteration (found at right-clicking Team Project, then "Team Project Settings">"Areas and Iterations...") & also referring to Work Item - Team Query "Iteration 1\Iteration Backlog".
If you managed to edit/delete those two, the Excel functionality shall be broken. Try to restore those back & the Excel shall work again. Then go to Excel Ribbon "Team" and choose "Configure\List" & set a valid query, pointing to a valid Iteration within your Team Project.
You can now delete the query, as well as the Team Project Iteration.
I had found this resolution here - (it's in German) & it was a lifesaver
还有另一种可能成功的途径，部分取自这里：
打开Visual Studio，选择Team ->团队项目集合设置->流程模板管理器。您可以将 MSF 5 模板下载到硬盘上的文件夹中。然后导航到
您下载到的文件夹\MSF for Agile Software Development v5.0\Windows SharePoint Services\Shared Documents\Project Management\
在此文件夹下，您将看到（现在无连接）Iteration Backlog.xlsm。
打开它&在“团队”下选择“新列表”&将其连接到您的查询“迭代 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.
我也遇到同样的问题。尝试以下更改后，它开始工作。
从 Azur 中的编辑查询检查您的查询是否使用“@RecentProjectActivity”等变量，然后将其替换为其他可能的静态引用，例如您可以引用某些区域路径或任何 ID。希望它能解决您的问题。谢谢。
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.
我得到这个是因为查询迭代 1/迭代积压不起作用，因为我更改了迭代结构但没有相应地更新查询。
因此，如果出现此错误，请检查 Excel 列表正在使用的查询是否正常工作。
I got this because the query Iteration 1/Iteration Backlog didn't work because I had change the iteration structure but not updated the query correspondingly.
So if you get this error, check that the query that the Excel list is using is working.
使用 @ 宏（如“@currentiteration”）时遇到类似的问题。
Excel 2013 不支持导入带有过滤器的查询，其中宏将添加为列表
将 @currentiteration 更改为迭代的绝对名称解决了该问题
Faced similar problem when using @ macros like '@currentiteration'.
Excel 2013 is not supporting importing Query with filters with macros to be added as List
Changing @currentiteration to absolute name of iteration resolved the issue