PRJ: Pasting Information into Project from Another Application

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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.
prj2000 1.0

Article ID: 60989 - Last Review: 02/27/2014 18:30:00 - Revision: 5.0

  • Microsoft Project 2000 Standard Edition
  • Microsoft Project 98 Standard Edition
  • Microsoft Project 4.1 Standard Edition
  • Microsoft Project 1.0 Standard Edition
  • Microsoft Project 3.0 Standard Edition
  • Microsoft Project 4.0 Standard Edition
  • Microsoft Project 3.0 for Macintosh
  • Microsoft Project 4.0 for Macintosh
  • Microsoft Project 2002 Standard Edition
  • Microsoft Project 2002 Professional Edition
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Standard 2003
  • Microsoft Office Project Professional 2007
  • Microsoft Office Project Standard 2007
  • Microsoft Project Professional 2010
  • Microsoft Project Standard 2010
  • kbnosurvey kbarchive kbhowto kbinterop KB60989