Others

Create a Microsoft Project Master Plan from Multiple Projects

Phi Hung VoPhi Hung Vo Nov 20, 2026 869 views

Question details

Combine multiple workstream plans into a master plan or link projects through interproject dependencies.

Create a Master Plan from Multiple Microsoft Project Files
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.
Before you start

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.

Solution 1Recommended

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.

1
Create the master

In Microsoft Project, select File > New and create a blank project for the master plan.

2
Insert each project

On the Project tab, select Subproject, choose a project file, and make sure Link to project is selected. Repeat for the other workstreams.

3
Review the combined plan

In the Gantt Chart view, expand the inserted project summary tasks to review the workstream schedules and any existing external dependencies.

4
Save and maintain the links

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.

Insert linked subprojects into a dynamic master plan
Master links and task dependencies are separate: Inserting a linked subproject connects the master to the project file; it does not automatically create dependencies between tasks in different projects.
Free Microsoft Office alternative

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.

Review and share project reporting data exported to a spreadsheetWork with Microsoft Excel XLSX and Word DOCX filesUse a familiar interface for a smoother move from Microsoft OfficeAccess lightweight office tools for free
microsoft office alternative - wps office

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.