How to Link Project Summary Tasks Without Importing Subtasks
Question details
The user needs to consolidate multiple Microsoft Project files into an executive-level master project that displays only summary tasks, preventing online viewers from exceeding line limits.
- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Creating a high-level master project dashboard from several smaller subprojects without expanding all subtasks, specifically to bypass viewer line restrictions.
- Observed behavior
- Importing smaller projects directly into a master file expands all tasks, which exceeds the approximate 400-line limit in online viewers and makes the executive view impractical.
Ensure all your individual Microsoft Project (.mpp) files are saved and accessible in the same directory, and verify the maximum line limit for your specific version of Project Online or Project for the web.
Insert Subprojects and Apply the Summary Tasks Filter
Use the built-in Summary Tasks filter to hide all individual subtasks across imported projects, keeping your executive dashboard within line limits.
By inserting subprojects into a master file, Microsoft Project initially imports all tasks. However, applying a display filter allows you to hide the granular details while maintaining all underlying scheduling data and predecessor relationships.
Launch Microsoft Project and open the blank or existing executive-level master project file where you want to display the summaries.
Navigate to the 'Project' tab on the ribbon and click on 'Subproject'. Select and insert each of your smaller project files into the master document.
Once all subprojects are inserted, go to the 'View' tab on the ribbon. Locate the 'Data' group.
Click the 'Filter' dropdown menu (which usually says '[No Filter]' by default) and select 'Summary Tasks'. This will instantly hide all subtasks and display only the high-level summary tasks for each subproject.
Manage Project Timelines Flexibly with WPS Office
If strict line limits in Microsoft Project Online are hindering your executive reporting, consider tracking project summaries with WPS Spreadsheet. It offers a highly compatible, free, and lightweight solution for building unrestricted project dashboards.
- 1. Download WPS Office: Visit the official WPS Office website and install the free suite on your device.
- 2. Open a Project Template: Launch WPS Spreadsheet and browse the built-in template library for 'Gantt Chart' or 'Project Tracker' to get a head start.
- 3. Customize and Share: Input your project summaries, customize the layout without worrying about line restrictions, and save your file in the standard .xlsx format.
Frequently Asked Questions
Why does Microsoft Project Online limit the number of displayed lines?
Project Online and Project for the Web are browser-based applications that impose performance limits, often capping views at around 400 lines, to ensure the software remains responsive and loads quickly.
Does hiding subtasks affect the master project timeline or calculations?
No. Filtering out subtasks only changes the display. All underlying predecessor relationships, successor links, and task durations remain intact and continue to calculate accurately in the background.
Can I export only the filtered summary tasks to share with executives?
Yes. Once you apply the Summary Tasks filter in the master project, you can print or export the current view to PDF or Excel. The resulting file will only show the summary lines visible on your screen.
