title: TFS2010: Opening certain Excel reports gives error TF80076
body: <p>When I try and open certain TFS2010 Excel reports I get the following error popup from Excel:</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/o27Ao.png" alt="TF80076"></p>
  
  <p>This is then followed by the popup:</p>
  
  <blockquote>
    <p>TF208103: The initialization of the
    workbook to connect to Team Foundation
    Server was not successful. THe
    workbook will close.... etc. etc..</p>
  </blockquote>
  
  <p>... and Excel closes.</p>
  
  <p>The reports that throw this error include:</p>
  
  <ul>
  <li><p><strong>Documents -> Samples and Templates ->
  Project Management -> Document
  Template - Iteration Backlog.xlsm</strong> (in
  fact all reports in this directory
  fail)</p></li>
  <li><p><strong>Documents -> Shared Documents ->
  Iteration 1 -> Issues.xlsx</strong> (and all
  reports in this directory also fail)</p></li>
  </ul>
  
  <p>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.</p>
  
  <p><strong>Any ideas how to fix these errors?</strong></p>
  
  <p><strong>Is there a way to regenerate the reports that error on the SharePoint site so that they can rebind with the project?</strong></p>
  
  <p>Thanks!</p>