Forum Discussion
It should be so simple…
RJP --
I have some bad news for you, my friend. Yes, you will need to create a master project containing all 100 projects. You will need to collapse every subproject so that only the Project Name is shown. On the other hand, if you were using an enterprise tool such as Project Online or Project Server, you would simply print the Project Center page which displays a single line for each published project. So, you are experiencing one drawback from managing desktop-only projects using Microsoft Project. Hope this helps.
I just need to show 100 start stop dates for 100 projects on a gantt chart. I am struggling to achieve it on excel as well. Any suggestions friend?
RJP --
Creating a master project to accomplish this reporting need would be way simpler than trying to create this in Excel. What you are asking is not as simple as you think it should be, which is that you want to report on high-level information about every project in your portfolio. This is not simple in Microsoft Project desktop, which is the tool you are using; but is a built-in feature of both Project Online and Project Server.
So, I think you should create the master project in Microsoft Project with the columns you want to see, and then save the master project. Whenever you update any of the 100 projects, the updates will flow into the master project automatically. Hope this helps.
I just need to make 100’s of project files, just to put a start stop date in…. Looong time. I have a client that wants to a gantt of when we start and stop all sorts, from ppms, reactives to big projects… I have all the data i need in excel, just knowing where to dump it to just do this for me without making up 330 files i have 330 jobs….
