Others

How to Fix Microsoft Project Leveling Errors and Overlapping Dates

Natalie Taylor Oct 23, 2026 868 views

Question details

Users are experiencing persistent resource leveling errors and overlapping dates in Microsoft Project, where residual overallocations remain even after running the leveling function.

How to Fix Microsoft Project Leveling Errors and Overlapping Dates

Product: Microsoft Project
Device & OS: not provided
Scenario: Managing project schedules and attempting to level resources to automatically resolve task conflicts and overallocations.
Observed behavior: Tasks continue to overlap, and overallocations are not resolved. This happens due to locked actual dates, unusual calendar settings, date constraints, or negative lag applied to dependencies.

Before you start

Before troubleshooting, ensure all your tasks are set to Auto Scheduled mode rather than Manually Scheduled, as manual scheduling prevents automatic leveling adjustments from functioning correctly.

Solution 1Recommended

Review Task Dependencies, Constraints, and Lag

Fix overlapping dates by ensuring dependencies are standard and removing hard constraints or negative lag.

Unusual dependencies, negative lag (such as FS-4d), and rigid date constraints can block Microsoft Project from correctly calculating and moving task dates during the leveling process.

Adjust Task Dependencies

Ensure predecessor and successor relationships use standard Finish-to-Start (FS) links with zero lag wherever possible.

Remove Negative Lag

Check your predecessor links for negative lag values (e.g., 3FS-4d). Negative lag forces a successor to overlap with its predecessor, undermining the leveling process. Replace these with standard relationships.

Clear Date Constraints

Open task settings and remove hard date constraints like 'Must Start On' or 'Must Finish On'. Change the constraint type to 'As Soon As Possible' to allow the leveling engine to move tasks dynamically.

Review Task Dependencies, Constraints, and Lag

Solution 2

Align Calendars and Enable Work Splitting

Ensure project, task, and resource calendars are aligned and allow the software to split remaining work for in-progress tasks.

Free Microsoft Office alternative

Manage Project Timelines Easily with WPS Office

While Microsoft Project is a dedicated tool for complex resource leveling, many users find it easier and more cost-effective to manage project schedules, timelines, and Gantt charts using WPS Spreadsheet. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for your daily productivity and project tracking needs.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open a Project Template: Launch WPS Spreadsheet, go to the Homepage, and search for 'Gantt Chart' or 'Project Schedule' in the extensive Template Library.
3. Track Your Project: Fill in your task names, assignees, dates, and durations to automatically generate a visual schedule without dealing with complex leveling errors.

Create project timelines and Gantt charts easily using free built-in templates.Highly compatible with Microsoft Excel (.xlsx) formats for seamless schedule sharing.Lightweight software with a familiar, easy-to-use interface.Completely free core features for individuals and small teams.

microsoft office alternative - wps office

Frequently Asked Questions

Why are completed tasks causing resource overallocations?

Once a task has actual start, duration, and finish dates recorded, it is considered completed or in-progress. The leveling engine cannot automatically move these actual historical dates, meaning any overallocations that occurred during that timeframe are permanently locked.

What does negative lag mean in a project schedule?

Negative lag is a predecessor link condition that creates lead time, such as 'FS-4d' (Finish-to-Start minus 4 days). This forces a successor task to start before its predecessor finishes, deliberately causing overlapping dates that resource leveling cannot easily resolve.

How do unusual calendars affect resource leveling?

If a specific task or assigned resource utilizes a different calendar than the main project calendar (e.g., distinct working hours, shifts, or holidays), it can create 'off calendar' scheduling conflicts. This prevents the leveling engine from cleanly moving tasks into available working hours.

How do I fix tasks that won't move during leveling?

Ensure the unmoving tasks are set to Auto-Scheduled. Remove any 'Must Start On' date constraints, clear negative lag from predecessors, and verify you have checked the option to 'Allow leveling to create splits in remaining work' in the Resource Leveling settings.

Office Quick Solutions