How to combine multiple project plans into one, but keep separate editing access?
I am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We consolidated all plans into one but this has created a large number of issues as we have 20 people all trying to edit and update at the same time. I want to allow for the PM's to have their own plan in their own sheet, and pull all of this into one sheet that is just viewing for everybody. I have tried to create a report with all the sheets but this removes the hierarchy of their activities. I also want to tag dependencies to separate workstreams. So can you tag a predecessor in another sheet that connects all of these together? Please let me know any suggestions to get this to work because having 20 people in the same sheet editing at the same time does not work!