How to Fix Microsoft Project Duration and Resource Leveling Problems
Question details
Users need to resolve issues where Microsoft Project fails to properly update overall project duration or level resources according to constraints.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Scheduling tasks and managing team workloads using predecessors, fixed units, effort-driven scheduling, and automatic baselines.
- Observed behavior
- The software does not update task or project duration as expected and resource leveling fails to resolve overallocations.
Before adjusting settings, ensure you have saved a backup copy of your current project file to prevent accidental loss of complex scheduling data.
Verify Task Priorities and Leveling Options
Check your task priorities, scheduling modes, and resource leveling options to ensure Project has the correct parameters to resolve conflicts.
Microsoft Project relies heavily on task constraints, priorities, and scheduling modes (Auto vs. Manual). If leveling fails or durations do not update, these settings are often the root cause.
Select the affected tasks, navigate to the 'Task' tab on the ribbon, and ensure they are set to 'Auto Schedule'. Manually scheduled tasks do not automatically update their duration when predecessors change.
Double-click a task to open the Task Information dialog box, or right-click and select 'Information'. Go to the 'General' tab and check the Priority field. Tasks set to a priority of 1000 will not be delayed by the resource leveling tool.
Navigate to the 'Resource' tab and click on 'Leveling Options'. Review the checkboxes for 'Leveling can adjust individual assignments on a task' and 'Leveling can create splits in remaining work' to give the software more flexibility in resolving overallocations.
Look for inflexible constraints like 'Must Start On' or 'Must Finish On' in the Advanced tab of the Task Information window, as these can block the automatic updating of project duration and resource leveling.

Track Projects Efficiently with WPS Office
If you are frustrated by the complexity of advanced project management software, WPS Spreadsheet offers a highly compatible, free, and lightweight alternative. You can easily manage task durations, build Gantt charts, and track resource allocations using familiar spreadsheet tools.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free office suite and install it on your computer.
- 2. Open WPS Spreadsheet: Launch WPS Office and start a new Spreadsheet document.
- 3. Apply a Project Template: Click on the 'Templates' tab and search for 'Project Management' or 'Gantt Chart' to quickly set up your project tracker.

Frequently Asked Questions
Why is my overall project duration not changing when I update tasks?
This frequently happens if the affected tasks or summary tasks are set to 'Manually Scheduled'. Ensure that the task mode is changed to 'Auto Schedule' so that duration calculations cascade correctly through your task predecessors.
What does 'fixed units' mean in Microsoft Project resource assignments?
A 'fixed units' task type means the percentage of a resource's time dedicated to a task remains constant. If you increase the task's duration, the total work (effort) will increase, but the resource's daily assigned units will not change.
How do I fix a resource overallocation without extending my project deadline?
To resolve overallocations without delaying the finish date, you can reassign the overallocated tasks to other available resources, authorize overtime work, or reduce the total work required for the specific task.
Why did my project baseline values disappear?
Baseline values only appear if you have explicitly captured them. If they are missing, you may not have saved the baseline for new tasks. You can save or update it by going to the 'Project' tab and clicking 'Set Baseline'.




