How to Fix Microsoft Project Not Merging Data into Master Projects
Question details
The user needs to merge Excel or project-plan data into a Microsoft Project master plan across multiple subprojects using Unique IDs.

- 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.
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.
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.
Organize your Excel data so that it is mapped to the individual subprojects rather than the master project.
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.
Alternatively, utilize Python scripts to automate the data loading process across your individual project files to minimize manual intervention.

Delegate Updates to Individual Schedulers
Distribute the workload by having each project manager update their respective subproject.
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. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Open Project Data: Launch WPS Spreadsheet and open your existing Excel project tracking files.
- 3. Manage and Merge: Use built-in data consolidation and VLOOKUP features to easily merge project data without complex master-plan pointer issues.

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.




