Creating Master Projects & Subprojects

tim.runcie

One of the key skills that we hear about in Project to Portfolio management is having a handle on multiple projects and viewing the integration between projects. Yet this can be a pain point for project managers who don’t have access to an enterprise system like Project Server or Project Online, but want to create views, reports, snapshots or to link project files together (essentially tying tasks from one project to another file).

 

I find that the best way to create integrated activities as well as a snapshot report of work over time is to leverage the Master Project in MS Project.

 

In this article, I’m going to give you a few best practices around creating a Master Project. And in case you were wondering, this will definitely scale if you need; my company and I have managed programs and portfolios of $500,000,000 and upwards using this technique.

 

Benefits of a Master Project:

So why use a Master Project?

  • Master projects give you the ability to create a permanent collection of projects that can be viewed at any time.
  • When viewing your project list, a Master Project will enable you to view the master project and subprojects all at one time in a list.
  • It allows you to create consolidated project reporting.
  • It is a way to link different project files together, meaning you can link different tasks between project through the Master Project
  • You can establish snapshots (non-linked schedules) so you can historically review progress over time vs. trying to have multiple columns of dates and times within a single file.

Getting Started:

Before you begin creating your master project you will need to determine if you want each subproject’s SharePoint site to be available in the master project SharePoint site. If yes, then do not publish the subproject until the master project is published. Once the subprojects have been saved, checked in and closed – but not published – you are ready to create your master project.

 

Step #1: Using Project Pro, create a new blank project and select the sub project tab

 

Step #2: Navigate to your first subproject and click on it one time only. Then click the circle next to the appropriate mode and select insert.

 

2

 

To add additional subprojects, select a new blank row within the master project and repeat steps above.

 

Step #3:  Once you have selected all the subprojects you want to include in the master project, click the file tab to save your master project and any changes to the subprojects as needed.

 

Step #4: The dialogue box below will pop-up and you can name and save your master project.

 

Step #5: The dialogue box below will pop-up; Select “No to all” if you inserted your subprojects as read only.

 

5

 

 

Now you are ready to publish or save your master project & create the SharePoint Site

 

 

Step #6: Select the File tab from Projects Ribbon

 

6

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Step #7: Click “Publish” if you are connected to Project Online or Project Server. If you are working on a local file, select Save As and save the master project file into a local directory. Note that your subproject files also need to be accessible from the file that you are using as a Master, meaning that you should save them in a directory where you also have access to them.

 

7

 

If you are connected to an Enteprise version of Project, you will Publish the changes. NOTE that you may choose to not save any changes to local files that were inserted.

 

8

 

 

Step #8: The dialogue box below will pop-up; Select “No to all” if you inserted your subprojects as read only, or Yes to all if you want to update your local files if you made changes.

 

One of the nice parts about saving and publishing files into an Enterprise version of Project is that you can have Project Server or Project Online automatically create an entire SharePoint site for you connected to your project.

 

That way if you decide to link files, documents, deliverables, issues and risks, you can have them connected and available for viewing or assigning them to the actual tasks in Project.

 

Step #9: The dialogue box below will pop-up; select “Publish” if you are connected to the Enterprise version of Project, or it will present a Save As dialog box for all local files seen in picture #2 all the files that you have inserted.

9

 

 

 

 

 

 

16

 

 

 

 

 

 

 

 

 

 

 

 

 

Once publish is complete you can close and check master project in. Now you are ready to publish the subprojects (you will need the URL information from Step 8).

 

Step #10: Open subproject and then click check out → File & Publish (choose File Save As for saving local version of MS Project).

 

10

 

Step #11: The dialogue box below will pop-up; select Publish.

Then close and check project in.  Repeat steps for all subprojects.

 

11

 

 

 

 

 

 

 

 

 

 

 

 

Then close and check project in.  Repeat steps for all subprojects.

 

Creating Snapshots of Projects:

One way that you can create historical snapshots of single and multple projects is to use the Master Project, but instead of having linked files, choose not to link them.

 

This is an excellent way to not only take snapshots, but in Project 2007 or higher, you have the ability to compare project files against each other to see where there are differences.

 

Here is an example:

Step #1:  Click on the Project Tab and Select Subproject

 

12

 

 

 

 

 

 

 

 

Step #2:  Once you have selected this, it will bring up the insert Project dialogue box, ensure that you turn off the check box for “link to project”

 

13

 

With the Link to Project turned off, any and all projects will simply be inserted as regular tasks with a Summary task for the top level row of the project.

 

14

 

 

 

 

 

 

Notice the standard Project file icon is not there.

 

Each of these files are embedded as if you had copied and pasted them and are not linked to the original file.

 

If you ever want to compare one version of a Project file to another, simply use the Compare Projects button found on the ribbon.

  • If you are in MS Project 2010, it will be found on the Projects Tab
  • If you are in MS Project 2013, you will find it on the Reports Tab

15

 

 

 

 

 

 

 

 

This screenshot is of 2013.

 

And there you have it. The ability to connect and view multiple files, do resource assignments, link tasks and also to create snapshots all with the same function of a “Master Project”. If you have any questions, don’t hesitate to reach out to me or anyone at our office at www.Advisicon.com.

 

Happy Project Management!

 

~Tim Runcie, PMP, MCT, MCTS, P-TSP, MVP

 

About
Showing 5 comments
  • Mario

    Thank you for this article, great reading!

    /Mario

  • Hessel

    This is very informative.

    I created two master projects but was unable to save them in a single “super” master project as project server 2013 did not let me publish the single “super” master project.

    Do you have any suggestions?

  • geekarmy

    Great share, very good article. Best regards.

  • William

    Hello,

    Thanks for the great article. I am a little stuck at this point because I want it all.

    I am using SharePoint online and I have several subprojects that I want to have my staff maintain. However, I would like to also view them through the SharePoint site. Currently, any subproject with the project logo, will sync fine but will not display. If I UNLINK them, I get the view I need but any updates to the subproject are not reflected on the master project.

    Any advice? Is there a way to force an update/sync from the original subproject?

  • pam.greensky
    pam.greensky

    Good Afternoon,

    Thanks for submitting the comments. Please email your questions to Contact@Advisicon.com, and I will have one of our senior consultants respond & work with you on finding some answers.

    Have a great day!
    ~Pam

Leave a Comment

Advisicon is a Project, Program & Portfolio Management Company. We transform your organization's project management with a mix of methodology and technology that delivers results. Our team specializes in technology implementations, application and workflow development, training and consulting.
5411 NE 107th Ave, Suite 200
Vancouver
WA
98662
United States