Microsoft KB Archive/113722

{|
 * width="100%"|

PRJ: Work Value Changes to 0 When Merging .MPX File

 * }

Q113722

-

The information in this article applies to:


 * Microsoft Project for Windows, versions 3.0, 3.0a, 4.0
 * Microsoft Project for the Macintosh, versions 3.0, 4.0

-

SYMPTOMS
In Microsoft Project, when you merge an .MPX file into an existing project file, the work value for a task is set to 0 if the task in the existing project has a resource assigned, and the task in the .MPX file does not.

CAUSE
When you merge an .MPX file into an existing project, information is merged at the record level, not the field level. This means that resource assignments for a task in the .MPX file replace the resource assignments for a task with the same unique ID number in the existing project. Resources assigned to a task are not merged with existing resources assigned to the task.

Therefore, if you merge an .MPX file that contains a task with no resource assigned into an existing project where the task does have an assigned resource, the resource in the existing project is no longer assigned to the task.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Steps to Reproduce Behavior in Microsoft Project 4.0

 * 1) In a new project, enter a task, T1.
 * 2) From the File menu, choose Save As. In the File Name box, type Task. From the Save File As Type list, select .MPX 4.0 and choose OK.
 * 3) In Project1, select the task T1. From the Standard toolbar, choose the Resource Assignment button. In the Name column, type Res1 and press ENTER. Choose the Assign button.
 * 4) From the Tools menu, choose Macros. Choose the New button. In the Macro Name box, type Merge_MPX and choose OK. In the new module, enter the following macro:
 * 5) From the View menu, choose Gantt Chart. From the Tools menu, choose Macros. From the Macro Name list, select Merge_MPX and choose Run. In the Open dialog box, select TASK.MPX from the File Name list and choose OK.

Work for T1 is 0 and the resource Res1 is no longer assigned to T1, though Res1 is still available in the Resource Assignment dialog box.