Others

Fix Microsoft Project Constraints, Earned Value & P6 Migration

Huda QurayshiHuda Qurayshi Nov 3, 2026 868 views

Question details

The user needs to fix a corrupted Microsoft Project schedule where tasks ignore constraint dates and produce incorrect earned value (BCWP), while evaluating a migration to Primavera P6.

How to Fix Microsoft Project Constraints, Earned Value, and P6 Migration Issues
Product
Microsoft Project
Device & OS
not provided
Scenario
Managing a 3-year-old project schedule migrated from Project 2013 to 2019, calculating earned value via Physical % Complete, and evaluating an export to Primavera P6.
Observed behavior
Tasks fail to honor assigned constraint dates, the Move Tasks feature does not update constraints, and earned value (BCWP) calculations are incorrect due to potential file corruption.
Before you start

Save a backup copy of your existing Microsoft Project (.mpp) file to a separate local folder before attempting any XML conversions or altering baseline data.

Solution 1Recommended

Fix Constraint Dates and Rebuild the Corrupted File

Resolve issues where tasks ignore constraint dates by verifying scheduling options and generating a clean file to eliminate corruption.

Files that have been heavily copied and modified over several years often develop background corruption. Rebuilding the file via XML export is a standard way to clear this corruption while preserving schedule data.

1
Verify scheduling settings

Go to File > Options > Schedule. Scroll to the Scheduling options section and ensure 'Tasks will always honor their constraint dates' is checked.

2
Check individual task constraints

Double-click the affected task to open the Task Information dialog. Navigate to the Advanced tab and verify that the Constraint Type and Constraint Date are set correctly.

3
Rebuild the project file

Go to File > Save As and choose 'XML Format (*.xml)' from the format dropdown. Close the current project, then go to File > Open and select the newly created XML file. Choose 'As a new project' to generate a fresh, uncorrupted .mpp file.

Success Tip: After saving the new .mpp file, try using the Move Tasks feature again to see if the constraint dates now properly align with the scheduled start dates.
Free Microsoft Office alternative

Manage Project Data Seamlessly with WPS Office

If complex legacy Microsoft Project files are causing persistent corruption issues, consider tracking your project data, budgets, and simple schedules using WPS Office. It provides robust spreadsheet tools perfect for project management tasks without the overhead of heavy specialized software.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
  2. 2. Open WPS Spreadsheet: Launch the application and select WPS Spreadsheet to create a new project tracker.
  3. 3. Apply a Project Template: Click 'New' and search for 'Project Management' or 'Gantt' in the template library to start tracking your schedule.
Highly compatible with Microsoft Excel (.xlsx) formats for easy schedule sharing.Built-in spreadsheet templates for Gantt charts, budgeting, and project tracking.Lightweight and stable, avoiding the deep file corruption common in legacy scheduling software.Completely free to use with a familiar, tabbed interface for quick adoption.
microsoft office alternative - wps office

Frequently Asked Questions

Why are tasks in Microsoft Project ignoring my constraint dates?

This usually occurs if 'Tasks will always honor their constraint dates' is unchecked in the Schedule Options (File > Options > Schedule). It can also happen if the .mpp file has developed underlying corruption after years of use.

Why is the BCWP (Earned Value) calculating as zero?

BCWP requires a saved project baseline to calculate properly. If no baseline is set (Project > Set Baseline), or if the task's Earned Value method is set to Physical % Complete but the physical completion hasn't been updated, the BCWP will be incorrect.

How do I clear corruption from a Microsoft Project file?

The most reliable method to clear file corruption is to save your .mpp file as an XML document (File > Save As > XML), close the file, and then open the newly created XML file back into Microsoft Project to generate a clean .mpp file.

Can I perfectly convert a Microsoft Project schedule to Primavera P6?

While you can export to XML or MPX to facilitate an import into P6, the conversion is rarely perfect. The two applications handle calendars, constraints, and resource levelling differently, which almost always necessitates manual cleanup and validation in P6.