Linked Fields fields

The Linked Fields field indicates whether there are OLE links to the task, resource, or assignment, either from elsewhere in this project file, from another Microsoft Office Project file, or from another program.

There are several categories of Linked Fields fields.

Data Type    Yes/No (Yes/No field: A type of field with content set to either Yes or No; also known as a Boolean field or a True/False field. For example, the Recurring field indicates whether the task is a recurring task.)

ShowLinked Fields (task field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    The Linked Fields field contains Yes when there is an OLE link to one of the task fields. The field contains No when there are no OLE links to any task field.

Best Uses    Add the Linked Fields field to a task sheet when you want to see whether the information for a task is a result of OLE links from somewhere else in the active project, another Project file, or another program.

Example    You have created OLE links from Microsoft Office Excel to various tasks in your schedule, and you want to see which tasks contain these links. You add the Linked Fields field to the Task Sheet view for added visibility.

ShowLinked Fields (resource field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    The Linked Fields field contains Yes when there is a link to one of the resource fields. The field contains No when there are no OLE links to the resource.

Best Uses    Add the Linked Fields field to a resource sheet when you want to see whether the information for a resource is a result of OLE links from somewhere else.

Example    You have linked resource information in your schedule from a Microsoft Office Excel spreadsheet containing personnel information. You want to group the resources containing these links. You add the Linked Fields field to the Resource Sheet view.

ShowLinked Fields (assignment field)

Entry Type    Calculated (calculated field: A field in which the value is determined by Project based on information in other fields. Project may recalculate the value automatically or when you specify, depending on your choice of calculation settings.)

How Calculated    The Linked Fields field contains Yes when there is an OLE link to one of the assignment fields. The field contains No when there are no OLE links to any assignment field.

Best Uses    Add the Linked Fields field to the sheet portion of the Task Usage or Resource Usage view when you want to see whether the information for an assignment is a result of OLE links from somewhere else.

Example    You have created OLE links from Microsoft Office Excel to various assignments in your schedule, and you want to apply a filter to display the assignments that contain these links. You add the Linked Fields field to the Task Usage view.

 
 
Applies to:
Project 2010, Project 2007, Project 2003