You can exchange information between Microsoft Project and Excel by embedding the source application as an embedded object in the target application. When you embed an object in one application that originated in a different application, you're basically inserting an entire file, with all of its source application's capabilities, into the target application.
This means that not only can you have a picture of a Gantt chart in an Excel worksheet, but you can double-click that Gantt Chart picture to access Microsoft Project commands to change data in the Gantt Chart. You can then switch to the Resource Sheet and change information there as well.
Likewise, in Microsoft Project, not only can you have just a picture of an S-curve graph generated by Excel, but you can double-click it to launch Excel and edit the format of the graph or even the underlying data for the graph.
Was this article helpful?
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.