Microsoft® Office Project 2007 Inside Out

Embedding Between Microsoft Project and Excel

You can integrate information from Microsoft Project and Excel by embedding a source file from one application as an embedded object in a file in the target application. When you embed an object in an application, you’re basically inserting an entire file, along with all of its source application’s capabilities, into the target application file.

Therefore, not only can you have a picture of a Gantt chart in an Excel worksheet, but you can double-click that picture of the Gantt chart to access Microsoft Project commands and change the Gantt chart data. You can even switch to a different Microsoft Project view, such as the Resource Sheet, and change information there as well. Likewise, in Microsoft Project, ...