Linking from Project to Excel

4 Click Edit, Paste Special.

5 In the Paste Special dialog box, click the Paste Link option.

Figure 17-13. Selected project data inserted into Excel as a linked picture. 7 Click OK.

The linked information appears at the worksheet selection (see Figure 17-14). When changes are made to the data in the project plan, those changes are reflected in this linked data in Excel.

Figure 17-13. Selected project data inserted into Excel as a linked picture. 7 Click OK.

The linked information appears at the worksheet selection (see Figure 17-14). When changes are made to the data in the project plan, those changes are reflected in this linked data in Excel.

Figure 17-14. Selected project data inserted into Excel as linked sheet text.
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment