Column data may be truncated in sheet view in Project

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 Q169726
This article has been archived. It is offered "as is" and will no longer be updated.
Symptoms
If you enter data that contains more than 255 characters in any column in Microsoft Project, the data may be truncated. 
Cause
This behavior occurs because the character limit in Project for any column in a sheet view is 255 characters. This is true regardless of the column's data type.
Workaround
If this problem occurs in the Notes field, you can work around the problem. To do this, type the text in one of the following places:
  • The Notes box on the Notes tab in the Task Information dialog box (on the Project menu) 
  • The Notes tab in the Resource Information dialog box (on the Project menu if you are using Resource sheet view) 

Note If you add the Notes column to your table and then edit the entry, any characters beyond the 255-character limit are truncated. 

If the column is of any other data type, you have to manually limit the number of characters that you enter to less than 255.

The Resource Names field is another field in which you can exceed the 255-character limit when you select multiple resources. It is still possible to assign all the resources by using the Task Information dialog box. The names will be truncated. However, the assignments are still valid and can be seen in the Task Information dialog box and in Resource Usage view.
prj2000
Properties

Article ID: 169726 - Last Review: 02/24/2014 08:28:59 - Revision: 9.0

  • Microsoft Project 2000 Standard Edition
  • Microsoft Project 98 Standard Edition
  • Microsoft Project 4.0 Standard Edition
  • Microsoft Project 4.1 Standard Edition
  • Microsoft Office Project Professional 2007
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Standard 2007
  • Microsoft Office Project Standard 2003
  • Microsoft Project 2002 Standard Edition
  • Microsoft Project 2002 Professional Edition
  • Microsoft Project Professional 2010
  • Microsoft Project Server 2010
  • Microsoft Project Standard 2010
  • Microsoft Project 2013 Professional
  • Microsoft Project 2013 Standard
  • kbnosurvey kbarchive kbprb kbusage KB169726
Feedback