Note: The timescale heading is converted to month, day, year format and displayed
in a single column.
To export role data
- From the Resources action menu in the global navigation bar, choose View Role Usage.
- To export allocation by project for a role,
choose Role Hierarchy in the Organized By field,
then select the role.
To export allocation by role for a role team, choose Role Team in the Organized By field, then select the team.
- Choose the Spreadsheet display option.
- To choose Units or Costs format, change the timescale, and show/hide limit data, click Customize.
- Click Export Spreadsheet.
- If prompted, choose to open or save the export file.
Tip: To view resources who can fulfill a role, click the role name.
If you choose to view the Excel file, Microsoft® Excel launches and opens the file, provided that Excel is installed on your computer. If you choose to save the file, accept or revise the default export file name and click OK.