View a spreadsheet of resource allocation for a specific project

Open one or more projects for which you want to view a resource spreadsheet.
In the Activities window, choose View, Show on Bottom, Resource Usage Spreadsheet.

You can also click the Layout Options bar, then choose Show on Bottom, Resource Usage Spreadsheet.
In the right pane of the Activity window's bottom layout, click the Display Options bar and make sure that Show All Projects is not selected.

To view resource allocation by resource, click the Display Options bar in the left pane of the bottom layout window, then choose Select View, By Resource.

To view resource allocation by role, click the Display Options bar in the left pane of the bottom layout window, then choose Select View, By Role.
In the Resource Assignments window, choose View, Resource Usage Spreadsheet.

You can also click the Display Options bar, then choose Resource Usage Spreadsheet.

Note

Dashes display in the cells of summary rows if your selection contains a mixture of labor/ nonlabor and material resources.