Others

Stop Microsoft Project Resource Assignments from Increasing Work Hours

Emma Brown Sep 27, 2026 869 views

Question details

Prevent Microsoft Project from automatically recalculating and increasing total work hours when new resources are assigned to a specific task.

How to Stop Microsoft Project Resource Assignments from Increasing Work Hours

Product: Microsoft Project
Device & OS: not provided
Scenario: Assigning new personnel or resources to an existing task in a project plan.
Observed behavior: The total work duration or value increases unexpectedly upon adding a resource, due to effort-driven scheduling.

Before you start

Verify your project plan permissions and identify the specific tasks where work hours are unexpectedly recalculating before adjusting your scheduling settings.

Solution 1Recommended

Disable Effort-Driven Scheduling for the Task

By turning off the effort-driven option in task properties, you can stop Microsoft Project from recalculating work values when adding resources.

Microsoft Project uses effort-driven scheduling by default for certain task types. This means the software attempts to keep the total effort constant, altering duration or work based on resource assignment. Disabling this feature ensures your defined work hours remain fixed.

Select the target task

Open your project file in Microsoft Project and click on the specific task that is experiencing unexpected work hour increases.

Open Task Information

Navigate to the 'Task' tab on the ribbon menu and click on the 'Information' button to open the Task Information dialog box.

Navigate to the Advanced tab

In the Task Information dialog box, click on the 'Advanced' tab to view scheduling configurations.

Clear the Effort driven option

Uncheck the box labeled 'Effort driven'. Click 'OK' to save your changes and apply the new scheduling behavior to the task.

Disable Effort-Driven Scheduling for the Task

Work Hours Stabilized: Once effort-driven scheduling is disabled, you can freely assign or remove resources without Microsoft Project automatically increasing the total work hours.

Free Microsoft Office alternative

Manage Project Schedules Effortlessly with WPS Office

If complex scheduling engines in Microsoft Project are overcomplicating your workflow, WPS Spreadsheet offers a free, lightweight, and highly compatible alternative. Easily track tasks, manage resources, and build Gantt charts using familiar spreadsheet interfaces without unexpected automated recalculations.

1. Download and Install WPS Office: Get the free WPS Office suite and open WPS Spreadsheet.
2. Access Project Templates: Click on 'New' and browse the template library by searching for 'Project Management' or 'Gantt Chart'.
3. Customize Your Schedule: Input your tasks, assign resources, and manage work hours manually without software overriding your inputs.

Seamlessly compatible with Microsoft Excel (.xlsx) files for sharing project plans.Free and lightweight alternative to heavy Microsoft Office management tools.Zero learning curve with a familiar, easy-to-use spreadsheet interface.Built-in templates for project timelines, Gantt charts, and resource tracking.

microsoft office alternative - wps office

Frequently Asked Questions

What is effort-driven scheduling in Microsoft Project?

Effort-driven scheduling is a calculation method where the total work for a task remains constant regardless of how many resources are assigned. While intended to decrease duration when adding resources, it can cause unexpected work hour shifts if task types are misconfigured.

Can I disable effort-driven scheduling for all new tasks globally?

Yes, you can change the default setting. Go to File > Options > Schedule, scroll to the 'Scheduling options for this project' section, and uncheck the 'New tasks are effort driven' box.

Why does task duration change instead of work hours when I add a resource?

This happens when your task type is set to 'Fixed Work' with effort-driven scheduling enabled. Because the total work is fixed, adding more resources (units) forces the software to decrease the duration to keep the calculation balanced.

Office Quick Solutions