TFS and Office 2010 Beta connections

I do a lot of work with TFS and one of the things I have to do is use Excel to deliver Gantt charts to management at the various clients I have.

I use excel to build a chart that reads the Interactions and assembles them (along with some sprint info) into a very workable chart that looks like a standard project management Gantt, but requires none of my time to produce.





The problem came when one client updated my Office install to the 2010 Beta (not that I was complaining at the time). The issue was, when I opened the spreadsheet that talks to the TFS server, I got a rude error saying that "TF84034: Team Foundation was unable to initialize the workbook". That was painful. I rely on this particular workbook to do most of my reporting overhead and wanted to get this resolved quickly.

After finding a few posts that talked about TFS 2010 (which we are not using yet) I found this post from Granth's Blog that wasn't quite the issue I had but it was close enough.

I downloaded the hotfix listed on this Microsoft page (FIX: You can no longer connect to a Team Foundation server from Excel after you insert a column in a worksheet) even though it wasn't my exact problem and it worked.