This article was previously published under Q60989
This article has been archived. It is offered "as is" and will no longer be updated.
When pasting information into Microsoft Project from another program, thecolumns of information that you are copying must match the columns ofinformation in the table in Microsoft Project that you are pasting into.Like Microsoft Excel, the information will be pasted into Microsoft Projectstarting at the upper-left cell of a selection. Unlike Excel, theremainder of a selection will be ignored and pasted information will mergeinto Microsoft Project, deleting the overwritten information.
Microsoft Project pastes information into the active table in a column forcolumn format. It will take the first column of information from theClipboard and try to put it in the first column of information in theactive table. If it doesn't match, the information is discarded andthe next column is processed until all the information is used fromthe Clipboard.
If you are pasting information into the default entry table in MicrosoftProject, the information must be set up in the same way the entrytable is in Microsoft Project (for example, ID, Name, Duration, etc.). Ifyou leave out a column, the information that gets pasted in will not bewhat you expected.
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 ofdata that it received; instead, it saw the Names and put them in the IDcolumn. It then took the durations and put them in the Task column andentered in the default durations when it didn't see a duration specified.
You always need to include the first column of information whenpasting information into Microsoft Project even if that column is inMicrosoft Project by default.
The information that would have worked in the above example is asfollows:
A B C --- ---------- ----- 1 Task 1 2d 2 Task 2 3d 3 Task 3 4d
This information would come across correctly when pasted into MicrosoftProject.