This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
Has anyone been able to figure out how to export an entire master project with multiple subprojects within it? Currently if I have 1 subproject in a master project all of the tasks are included in the export but as soon as I add an additional subproject, the master excel export only includes the summary tasks for the subprojects and I would like to have all of the tasks in the export.
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Did some additional testing and resolved the issue, thankyou! Must have been something with the files I was using because when I created new blank test files it all worked as expected
Hey John,
Another issue I wanted to ask about is the standard "ID" column that is included. When we are exporting a the master project, the tasks within each project restart at ID "1". Do you know if there is a way to continue the sequencing throughout all of the tasks across subprojects or somehow create another column that does this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 92%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Carter Wrobel,
I'm glad you got it resolved, thanks for the feedback.
John
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
Carter Wrobel,
First of all, what version of Project are you using? Second, how exactly are you "exporting" the structure?
When you export the master structure, are all subprojects fully expanded? If not, you will only get the summary line insertion points for un-expanded subprojects. Why? Because in a master/subproject structure, the subprojects are not part of the master, the master only contains pointers to each individual subproject so in order for subproject tasks to appear, each subproject must be fully expanded.
John