Others

How to Manage a Shared Resource Pool in Microsoft Project

Natalie Taylor Oct 23, 2026 868 views

Question details

The user needs to schedule tasks using a general pool of 25 workers and wants to prevent the software from assigning more than 25 workers on any single day.

How to Manage a Shared Resource Pool in Microsoft Project

Product: Microsoft Project
Device & OS: not provided
Scenario: Scheduling tasks and managing workforce capacity in a project management environment to ensure resource limits are respected.
Observed behavior: The user wants to avoid overallocating a shared pool of workers and needs a method to ensure the schedule automatically adjusts to the 25-worker limit.

Before you start

Ensure you have your worker group set up in the Resource Sheet with the 'Max.' capacity configured correctly (e.g., 2500% for 25 full-time workers) before assigning them to tasks.

Solution 1Recommended

Use Resource Leveling to Resolve Overallocations

Assign specific resources to your tasks first, allow temporary overallocations to occur, and then use the Resource Leveling tool to delay or split tasks automatically.

Microsoft Project does not automatically decide which specific workers should perform each task. The correct approach is to make your assignments manually and let the software adjust the task timing to respect your resource limits.

Assign Resources to Tasks

Open your Gantt Chart view. Select your tasks and assign the necessary number of workers from your resource pool to each task. Ignore any red overallocation indicators temporarily.

Open Leveling Options

Navigate to the 'Resource' tab on the top ribbon. In the 'Level' group, click on 'Leveling Options' to open the configuration dialog box.

Configure Leveling Rules

In the Leveling Options dialog, choose whether you want the leveling calculations to be 'Automatic' or 'Manual'. It is generally recommended to use 'Manual' so you maintain control over when the schedule changes.

Apply Resource Leveling

Click the 'Level All' button. Microsoft Project will automatically delay or reschedule tasks that cause your daily limit of 25 workers to be exceeded until all overallocations are resolved.

Use Resource Leveling to Resolve Overallocations

Understanding Leveling Behavior: Resource Leveling changes the start and finish dates of your tasks but does not change who is assigned to them. Ensure your task dependencies are set correctly so the leveling engine delays tasks in a logical order.

Free Microsoft Office alternative

Manage Project Schedules Effectively with WPS Office

If you need a simpler, cost-effective way to track project tasks and manage human resources, try WPS Spreadsheet. It offers a familiar interface, highly compatible formatting, and free Gantt chart templates to help you organize your team without the complexity of heavy project management software.

1. Launch WPS Spreadsheet: Open WPS Office and create a new Spreadsheet document to serve as your project tracker.
2. Search for Templates: Click on the 'Templates' tab and search for 'Project Management' or 'Gantt Chart' to find pre-formatted tracking tools.
3. Track Your Resources: Input your team members, assign task start and end dates, and visually track your 25-worker pool's availability.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) project trackers.Access a wide variety of free, built-in Gantt chart and project schedule templates.Lightweight performance that runs smoothly on Windows, Mac, Linux, and mobile devices.Completely free to use for everyday project management and tracking needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my resources show up in red in Microsoft Project?

A red resource indicator (often a red person icon) means the resource is overallocated. This occurs when you assign more work to a resource pool than their maximum capacity allows on a specific day. Using Resource Leveling will resolve this.

Can Microsoft Project automatically assign tasks to my workers?

No, Microsoft Project cannot intelligently pick which worker should perform a task. You must manually assign the resource pool to the task, and the software will then handle the timeline scheduling based on those manual assignments.

How do I define a 25-person resource pool in Microsoft Project?

Go to the Resource Sheet view, create a single Work resource (e.g., 'Construction Crew'), and set the 'Max.' column to 2500%. This tells the software that you have the equivalent of 25 full-time workers available for assignment.

What is the difference between Automatic and Manual leveling?

Automatic leveling immediately adjusts task dates the moment you assign an overallocated resource. Manual leveling waits until you click 'Level All', allowing you to make all your resource assignments first before shifting the project timeline.

Office Quick Solutions