- In Microsoft Office Project, open the project that contains the source (source: The location where moved, copied, imported, or exported information originated; can be a view, table, document, or other program. In OLE, the document or program that furnishes information to a linked object in a destination, document, or program.) field that you want to link (linking: In a project, establishing a dependency between tasks. Linking tasks defines a dependency between their start and finish dates. In OLE, establishing a connection between programs so that data in one document is updated when it changes in another.), and then select that field.
- Click Copy Cell .
Note This command changes to Copy Task if you select an entire task or a set of tasks in a task view, or to Copy Resource if you select a resource row or a set of resources in a resource view.
- Open the project into which you want to insert the information.
- On the View menu, click the sheet view that you want.
To use a view that is not on the View menu, click More Views, click the view that you want to use in the Views list, and then click Apply.
- Select the location where you want to paste the information.
When pasting a text object into a sheet view, select the field where the upper-left corner of the information should be pasted. Make sure that there are enough blank fields available to accommodate the object without overwriting existing fields.
- On the Edit menu, click Paste Special, and then click Paste Link.
Whenever you change the linked information in the source field, Project automatically updates it in the destination field.
Note Although you may be able to paste information into some calculated fields, Project might not either use the information or recalculate the value, because the field might also be recalculated based upon information in other fields.