Upload and Refresh Excel Reports in the Team Project Portal for Visual Studio ALM
After you create a report in Microsoft Excel that shows data for your team project, you can share that report with other team members. You can add the report to a shared folder or send it in e-mail, or you can upload the report to your team's project portal. To keep the report accurate, you might also want to run the report again on a particular schedule, such as every week or at each project milestone.
You can share Microsoft Excel reports just as you share any other document through the project portal. You can upload reports into the portal from either the portal itself or from Team Explorer. For more information, see Manage Documents and Document Libraries. After you have uploaded your reports, you can manage them the same way that you manage any other documents that you have uploaded to your portal. If you have many reports, you might want to group them within folders to make it easier to find specific reports.
When you view a report using Microsoft Excel, the data appears as it existed in the spreadsheet when the file was most recently saved. To display more current data, you must refresh the report. To refresh the report, you must have access to the same data source on which the report is based.
If your report is based on a work item query, you must refresh the contents of the work item list, and then you must refresh the PivotTable and PivotChart reports. To refresh a list of work items, you display the Team ribbon and then click Refresh. To refresh PivotTable and PivotChart reports, you open the Data menu and then click Refresh.
To maintain history for a report, you can save a copy of it every time that you refresh the data. If you need your reports to be refreshed automatically, you might consider using SQL Server Reporting Services to create your report instead. For more information, see Choose the Source of Data and Authoring Tool for Your Reports for Visual Studio ALM.