Q119348 - PRJ: Importing Resources with Units Creates Multiple Resources

PRJ: Importing Resources with Units Creates Multiple Resources

Q119348

The information in this article applies to:

Microsoft Project for Windows, versions 1.0, 3.0, 3.0a, 4.0
Microsoft Project for the Macintosh, versions 1.1, 3.0

SYMPTOMS

When task information is imported or copied into Microsoft Project, duplicate resources may be created.

CAUSE

Resources are duplicated if there is a space between the resource name and the unit, and the resource is assigned to more than one task.

WORKAROUND

Remove all spaces between the resource name and the unit before importing the task information into Microsoft Project.

Steps to Reproduce Behavior:

Enter the following into a Microsoft Excel worksheet:

(Note space between Bob and [units].)


    |    A    |     B
---------------------------
 1  | Task1   |   Bob [.3]
 2  | Task2   |   Bob [.4]

Select cells A1 through B2. From the Edit menu, choose Copy.

In Microsoft Project 4.0, from the View menu choose Table, More Tables and choose New. Create a the following table:


   Field Name      Align    Width    Title
   ----------      -----    -----    -----
   ID              Right    10
   NAME            Right    10
   RESOURCE NAMES  Right    10

Choose OK and the choose Apply.

From the Edit menu, choose Paste.

From the View menu, choose Resource Sheet.

RESULT: The resource Bob will be listed twice.

EXPECTED: The resource Bob should only be listed once.

STATUS

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

Additional query words: 1.10 3.00a duplicated

Keywords : kbinterop kbusage
Issue type : kbbug
Technology :