How To: Create TFS Reports Using Excel (PivotTable) I have customers that from time to time need new reports for them self not for the all project, I asked them why you need me to create this king of report? The answer is: I don't know how and it's too complicated... My answer: No it's not! In less then 5 min you will be able to create report like the one below that sync directly from TFS. Let's Start Open Excel 2007 click on Data tab and click on From Analysis Services . Enter TFS...