You can choose Resource Usage Spreadsheet fields to spread overallocated resources units over early and late dates.
- 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 bottom layout window, click the Display Options bar and choose Show All Projects, if it is not already selected. A check next to Show All Projects indicates that it is selected.
- Right-click in the spreadsheet, then choose Spreadsheet Fields, Customize. Select Overallocated Early Units and/or Overallocated Late units in the available options section, then click the right arrow to add the fields to the spreadsheet.
When a resource is spread over the early dates of activities, to view the number of units beyond the resource's limit that are planned over a given timeperiod, select Overallocated Early Units.
When a resource is spread over the late dates of activities, to view the number of units beyond the resource's limit that are planned over a given timeperiod, select Overallocated Late Units. - Click Ok.