Fix Microsoft Project Import Wizard Not Updating Subproject Tasks
Question details
The user needs to resolve an issue where the Import Wizard either ignores subproject tasks or incorrectly updates the main project tasks when merging Excel data using Unique ID as the merge key.

- Product
- Microsoft Project Online Desktop Client
- Device & OS
- not provided
- Scenario
- Updating tasks in a dynamic master project containing inserted subprojects via an Excel export and re-import process.
- Observed behavior
- The Import Wizard fails to safely merge data. It incorrectly uses subproject data to overwrite tasks in the main project, ignoring the actual subproject tasks due to Unique ID conflicts.
Before modifying any linked master projects, create direct backup copies of both the master project and all individual subproject files to a local directory to prevent accidental data corruption.
Update Subproject Files Directly
Because master projects and subprojects are fragile linked structures rather than flat files, you must update the individual subprojects directly instead of using the Import Wizard on the master project.
In a dynamic master project, subprojects are not actually part of the master project; the master simply contains pointers to each subproject file. Consequently, subproject tasks generate exceptionally large Unique IDs to avoid conflicts.
The Microsoft Project Import Wizard cannot safely handle these large Unique IDs when merging data from Excel. Exporting from a linked structure, editing in Excel, and re-importing is highly prone to overwriting the wrong tasks or completely corrupting the master project pointers.
Save your work and completely close the dynamic master project in Microsoft Project Online Desktop Client.
Navigate to the local directory where your project files are stored and open the specific subproject (.mpp) file directly.
Go to File > Open to launch the Import Wizard. Select your Excel file and map the Unique IDs to update the tasks directly within this isolated subproject file.
Save the subproject file. Open the master project again to verify that the linked data has safely and accurately updated.

Consolidate and Secure Linked Project Files
Ensure your master and subproject files are stored correctly to prevent the file pointers from breaking or corrupting during any data updates.
Simplify Your Project Management with WPS Office
If fragile linked structures and complex subproject errors in Microsoft Project are causing data corruption, consider streamlining your workflow with WPS Spreadsheet. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office for creating robust project trackers without the risk of broken file pointers.
- 1. Download and Install: Download WPS Office for free from the official website and follow the easy installation prompts.
- 2. Import Existing Data: Open WPS Spreadsheet and directly import your existing Excel-based project data or task lists.
- 3. Manage Projects Securely: Use built-in formatting and project management templates to track tasks securely in a single, stable file.

Frequently Asked Questions
Why do subproject tasks have completely different Unique IDs in the master project?
In a dynamic master project, inserted subprojects act as linked pointers. To prevent conflicts with the master project's normal sequential IDs, Microsoft Project assigns very large Unique IDs (e.g., 8388609) to the tasks located inside a subproject.
Can I store linked master and subproject files on SharePoint?
No, storing linked structures like master/subprojects or resource pools on SharePoint or shared network drives is not supported. Operating them over a network makes the file pointers fragile and highly prone to corruption.
Why did the Import Wizard overwrite a standard master project task instead of my subproject task?
When mapping Unique IDs during an Excel import, the Import Wizard struggles to handle the large Unique IDs generated by subprojects. Instead of safely bypassing or mapping them, it often misinterprets the data and overwrites sequential tasks in the main project.




