Others

Fix Microsoft Project Import Wizard Not Updating Subproject Tasks

Maira MehtabMaira Mehtab Oct 16, 2026 870 views

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.

How to Fix Microsoft Project Import Wizard Not Updating Subproject Tasks
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 you start

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.

Solution 1Recommended

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.

1
Close the Master Project

Save your work and completely close the dynamic master project in Microsoft Project Online Desktop Client.

2
Open the Target Subproject

Navigate to the local directory where your project files are stored and open the specific subproject (.mpp) file directly.

3
Run the Import Wizard on the Subproject

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.

4
Save and Verify

Save the subproject file. Open the master project again to verify that the linked data has safely and accurately updated.

Update Subproject Files Directly
Important Workflow Adjustment: Never use the Excel export and re-import method directly on a dynamic master project. Always update the individual source files to maintain project integrity.
Free Microsoft Office alternative

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. 1. Download and Install: Download WPS Office for free from the official website and follow the easy installation prompts.
  2. 2. Import Existing Data: Open WPS Spreadsheet and directly import your existing Excel-based project data or task lists.
  3. 3. Manage Projects Securely: Use built-in formatting and project management templates to track tasks securely in a single, stable file.
Highly compatible with Microsoft Excel (.xlsx) for seamless project data trackingFree, lightweight, and completely eliminates the risk of linked-file corruptionFamiliar user interface guarantees a zero-learning-curve migrationBuilt-in templates for project timelines, Gantt charts, and task management
microsoft office alternative - wps office

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.