Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

LinkBack Thread Tools Display Modes
Old 08-11-2017, 11:41 AM
rwcllc rwcllc is offline Windows 10 Office 2013
Join Date: Aug 2017
Posts: 1
rwcllc is on a distinguished road
Default Trying to get 3 layers of subprojects with a workaround.

I am trying to outsmart Project and get 3 layers of subprojects for reporting.

1. I have 45 subprojects which are dependencies which need to be done before other work can start.

2. I have 93 projects which each require 6 to 12 subprojects as predecessors.

Everything works well up to this point.

Now, I would like to have a summary schedule (3rd level) of the 93 projects for reporting purposes only. I would not manage or edit from the summary, but just use it for monthly reports.

If I try to create the create the summary schedule one project at a time, as soon as another project is added which share a subproject already in place, i get the error message, that multiple copies of a subproject are not allowed. Understood.

If I add all the projects at one time, however, all 93 will load. The first instance of each subproject will remain a subproject, with all other instances of that subproject breaking the link and becoming only a single top-level task. This destroys pretty much all of the links. I am OK with this, since for reporting I planned to 1. update my subprojects. 2. update my projects. 3. copy the projects to a separate reporting directory, where the links to the subprojects remain live, but as I build the summary project as above, the links break on the reporting projects, not the master file.

Anyway, it all seemed to work, with the subprojects that collapsed to tasks still retaining their finish dates so the summary project would maintain schedule logic. However, I noticed that some of them work fine, while some of the dates collapse to an arbitrary date, or the project start date, and I cannot find any logic to that. See the attachment, where lines 4, 5, and 7 collapsed with correct dates, line 6 is a subproject (the first instance), but lines 10 -12 all default to some arbitrary date (a previous finish date for one of line 10.

I know I am stretching the limits of MSP this way, but wonder if any can help, or offer an alternate way to get a summary schedule at the 3rd level.
Attached Files
File Type: mpp MSP EXAMPLE.mpp (281.5 KB, 1 views)
Reply With Quote

subprojects, summary

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Subprojects columns being mixed up hpatel517 Project 5 08-21-2016 05:37 AM
Windows GetOpenFileName Method Workaround for Excel 2011 on MAC Story11 Excel Programming 37 01-26-2015 09:34 PM
Index Hyperlink Workaround Phil H Word VBA 9 10-30-2014 05:14 AM
Workaround to have UserForm open from Web Link Kirsti Word VBA 11 08-23-2012 07:05 PM
Pls Help!! Inserting Subprojects... Dina Project 1 01-20-2011 09:55 AM

All times are GMT -7. The time now is 11:02 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft