PRJ: Pasting Information into Project from Another Application (60989)

SUMMARY

When pasting information into Microsoft Project from another program, the columns of information that you are copying must match the columns of information in the table in Microsoft Project that you are pasting into. Like Microsoft Excel, the information will be pasted into Microsoft Project starting at the upper-left cell of a selection. Unlike Excel, the remainder of a selection will be ignored and pasted information will merge into Microsoft Project, deleting the overwritten information.

Microsoft Project pastes information into the active table in a column for column format. It will take the first column of information from the Clipboard and try to put it in the first column of information in the active table. If it doesn't match, the information is discarded and the next column is processed until all the information is used from the Clipboard.

MORE INFORMATION

If you are pasting information into the default entry table in Microsoft Project, the information must be set up in the same way the entry table is in Microsoft Project (for example, ID, Name, Duration, etc.). If you leave out a column, the information that gets pasted in will not be what you expected.

Example

In Excel, set up a table that looks like this:

      A        B
   -------- -------
   Task 1        2d
   Task 2        3d
   Task 3        4d

Copy this information to the Clipboard.

Paste the information into the default entry table in Microsoft Project.

Your results in Microsoft Project will look like the following:

   ID    Name     Duration
   1      2d          1d
   2      3d          1d
   3      4d          1d

Microsoft Project was looking for the ID column to be the first column of data that it received; instead, it saw the Names and put them in the ID column. It then took the durations and put them in the Task column and entered in the default durations when it didn't see a duration specified.

You always need to include the first column of information when pasting information into Microsoft Project even if that column is in Microsoft Project by default.

The information that would have worked in the above example is as follows:

   A       B        C
   --- ---------- -----
   1   Task 1       2d
   2   Task 2       3d
   3   Task 3       4d

This information would come across correctly when pasted into Microsoft Project.