Link or embed Excel data into Project
You can insert data from Microsoft Office Excel into Microsoft Office Project as a linked object that will be updated dynamically by changes made in the source file. You can also embed the data independent of its original file.
-
In Excel, select the data (such as fields, cells, records, or rows) that you want to link or embed, and then click Copy .
-
In Project, on the View menu, click the 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 insert the data.
-
On the Edit menu, click Paste Special.
-
Do one of the following:
-
To embed the data independently, without a link to the source document, click Paste.
-
To link the inserted data to the data in the source document, click Paste Link.
-
-
Under As, click Text Data.
No comments:
Post a Comment