Create a Microsoft Project Master Plan from Multiple Projects
Question details
Combine multiple workstream plans into a master plan or link projects through interproject dependencies.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- A program manager needs a consolidated view of multiple project files for coordination or reporting.
- Observed behavior
- A master plan should show the workstreams together while preserving any required dependencies and avoiding broken file links.
Decide whether you need a live master linked to the source projects or a static snapshot for reporting. For linked files, choose stable file locations before creating the master and avoid moving or renaming the files afterward.
Insert linked subprojects into a dynamic master plan
Use a dynamic master when you need a consolidated view that remains linked to the individual project plans.
In Microsoft Project, select File > New and create a blank project for the master plan.
On the Project tab, select Subproject, choose a project file, and make sure Link to project is selected. Repeat for the other workstreams.
In the Gantt Chart view, expand the inserted project summary tasks to review the workstream schedules and any existing external dependencies.
Select File > Save As and save the master in a stable location. Avoid moving, renaming, overwriting, or creating copies of linked files, because the links can become unreliable.

Create a static master plan for reporting
Use a static master when you need a reporting snapshot that is not dynamically linked to the source project files.
Share Project Reporting Data with WPS Office
WPS Office is a free, lightweight alternative for working with exported project reports. Its familiar interface and Microsoft Office format compatibility make it easy to move reporting data into spreadsheets and documents. It does not replace Microsoft Project's master-plan or dependency features.

Frequently Asked Questions
Can I link tasks in different projects without creating a master plan?
Yes. Interproject task dependencies and linked subprojects are separate Microsoft Project features, so a master plan is not required for cross-project links. Keep the linked files in stable locations to reduce the risk of broken links.
How do I make an inserted subproject static?
In Microsoft Project, select Project > Subproject, choose the file, and clear Link to project before inserting it. The inserted data becomes a snapshot rather than a dynamic link to the source file.
Will interproject dependencies become normal task links in a static master?
Not automatically. Review the Predecessors and Successors columns after creating the static master, then add the required internal links manually or use a tested macro to convert them.
What should I do if I cannot select a SharePoint or OneDrive project file?
If the file cannot be selected directly, download it to a local folder before inserting it into the master. For a dynamic master, keep the local linked files in stable locations afterward.




