You can export a scorecard to an Excel spreadsheet (*.xls) file from a Portfolio View portlet on a dashboard and from the Portfolios > Portfolio Analysis page. When you choose to export a scorecard, you have the option to open the scorecard in Excel or save it to your computer.
To export a scorecard from a Portfolio View portlet, click Export Spreadsheet in the portlet, then choose to open or save the file (if prompted).
To export a scorecard on the Portfolio Analysis page, click above the scorecard you want to export, then choose to open or save the file (if prompted).
Notes:
-
Only WBS rows that you have previously expanded are exported to the *.xls file. If you expand a WBS row and then collapse it before exporting, the previously expanded rows are still exported.
-
For calculated user-defined field columns that display an icon, only the data in the column is exported to the *.xls file. For columns that display only an icon, no data is exported.
-
The Activities column is not exported to the *.xls file, even if it is displayed in the scorecard.