Edit a Report in Microsoft Excel for Visual Studio ALM

As conditions change on your team project, you might want to modify the Microsoft Excel reports that you use to manage the project. Also, you might want to modify your reports as new fields become available in the data warehouse or if you want to specify different records for the report.

You can update a PivotTable or PivotChart report by using new data that falls in your original source data specification by refreshing the report. When you refresh a report, you run the underlying query to retrieve new or changed data.

For more information about how to modify how data is summarized, see the following Microsoft Excel Help topics on the Microsoft web site:

Contact your Team Foundation Server administrator or your team project administrator to make sure that your user account has the permissions that are described in the following section.

Required Permissions

To perform these procedures, you must be a member of the TfsWarehouseDataReader security role in Analysis Services. For more information, see Grant Access to the Databases of the Data Warehouse for Visual Studio ALM.

To change a report stored on the local computer

  1. Open the Microsoft Excel workbook.

  2. Click the PivotTable cells. The PivotTable Field List dialog box appears.

  3. Make the changes that you want to either the fields in the PivotTable or to the appearance of the PivotTable. For more information about making changes, click Help.

  4. On the File menu, click Save.

    Note

    If you want to save the report in a static form that saves the current data, save the file in .xls format. If you want to save the report as a template that will refresh the data every time it is opened, save the file in .xlt format.

To change a report in Team Explorer

  1. In Team Explorer, expand the team project node, and then expand the Documents node.

  2. Right-click the Microsoft Excel workbook that you want to change, and then click Edit. The workbook opens in Microsoft Excel.

    Note

    If you want to alert other members of your team that you are making changes in the workbook, you should check the file out on the team portal and then make your changes. For more information about checking out and editing files, click Help on the team portal.

  3. Click the PivotTable cells. The PivotTable Field List dialog box appears.

  4. Make the changes that you want to either the fields in the PivotTable or to the appearance of the PivotTable.

  5. On the File menu, click Save.

    Note

    If you want to save the report in a static form that saves the current data, save the file in .xls format. If you want to save the report as a template that will update the data every time it is opened, save the file in .xlt format.

See Also

Tasks

Create a Report in Microsoft Excel for Visual Studio ALM

Concepts

Perspectives and Measure Groups Provided in the Analysis Services Cube for Team System

Creating Reports in Microsoft Excel by Using Work Item Queries

Creating and Managing Excel Reports for Visual Studio ALM