Managing Excel Reports for Team System in the Project Portal
After you create a report that shows data for your team project in Microsoft Excel, you probably want to share that report with other team members. If you do not want to put the report in a shared folder or send it in e-mail, 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 How to: Upload a Document in Team Explorer. 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.
To refresh a report that uses the analysis services database as a data source for Microsoft Excel, the SQL Server 2005 Analysis Services 9.0 OLE DB provider must be installed on the computer where you use Excel. You can find this provider on the Microsoft Download Center (http://go.microsoft.com/fwlink/?LinkId=94415).
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 Choosing a Tool to Create Reports for Team System.