Others

How to Fix Microsoft Project Not Merging Data into Master Projects

Muhammad TalhaMuhammad Talha Oct 28, 2026 869 views

Question details

The user needs to merge Excel or project-plan data into a Microsoft Project master plan across multiple subprojects using Unique IDs.

How to Fix Microsoft Project Not Merging Data into Master Projects
Product
Microsoft Project
Device & OS
not provided
Scenario
Managing large programs with over 10,000 lines and 20+ individual projects, attempting to load program-wide data efficiently at the master-plan level.
Observed behavior
Microsoft Project cannot merge data by Unique ID into the master project because the master file only uses pointers to subprojects, making identical Unique IDs across subprojects not globally equivalent.
Before you start

Ensure that you have backup copies of your master project file and all linked subprojects. Confirm you have access to the necessary VBA or Python scripting environments if you plan to automate data transfers.

Solution 1Recommended

Automate Data Transfers at the Subproject Level

Since master projects only contain pointers, you must merge data into each individual subproject separately using automation tools.

A linked master project in Microsoft Project does not actually contain the data from its inserted subprojects; it only holds pointers. Because of this, Unique IDs are only unique within their specific subprojects, not globally across the master project. To merge data effectively, you must load the data directly into the subprojects.

1
Prepare Subproject Data

Organize your Excel data so that it is mapped to the individual subprojects rather than the master project.

2
Use VBA or VSTO Add-ins

Write or execute a VBA macro or VSTO add-in designed to iterate through your list of subproject files, open them, and merge the relevant Excel data by their local Unique ID.

3
Run Python Scripts for Bulk Loading

Alternatively, utilize Python scripts to automate the data loading process across your individual project files to minimize manual intervention.

Automate Data Transfers at the Subproject Level
Design Limitation: This behavior is not a bug but a design feature of Microsoft Project. To request native global merging, submit feedback through the official Microsoft Project feedback channel.
Free Microsoft Office alternative

Manage Project Data Easily with WPS Office

While Microsoft Project handles complex scheduling, managing and merging large datasets across multiple files can be cumbersome. WPS Office provides a lightweight, highly compatible alternative for handling project data, tracking tasks, and collaborating seamlessly using familiar spreadsheet tools.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Project Data: Launch WPS Spreadsheet and open your existing Excel project tracking files.
  3. 3. Manage and Merge: Use built-in data consolidation and VLOOKUP features to easily merge project data without complex master-plan pointer issues.
Fully compatible with Microsoft Excel formats (.xlsx, .xls) for seamless project data management.Lightweight and fast, easily handling large datasets with thousands of rows.Free to use with a familiar, intuitive user interface.Built-in tools for data merging, filtering, and team collaboration.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Unique IDs duplicate in a Microsoft Project master plan?

A master project is a compilation of pointers to individual subprojects. Each subproject maintains its own set of Unique IDs starting from 1, meaning Unique ID 1 in Subproject A is completely separate from Unique ID 1 in Subproject B.

Is the inability to merge data into a master project a bug?

No, it is considered a design limitation. Microsoft Project master files are designed to link to subprojects rather than absorb their data, so global data merging by Unique ID is not natively supported.

Can I load data at the master level if I have write access?

While some data can be loaded at the master level, only one user can have active write access at a time. For large programs, it is highly recommended to update data at the individual subproject level to avoid conflicts.

How can I automate data entry for multiple subprojects?

You can use VBA macros, VSTO add-ins, or external scripts (like Python) to programmatically open each subproject, merge the necessary Excel data, and save the files without manual intervention.