Tools -> Options -> File Locations

OLE!

The technical term for what we did is called OLE: Object Linking and Embedding. Paste Special.

 

Suppose you go to Microsoft Excel and revise the rainfall data for August. Select Cell E2 type: 8.

 

When you hit the Enter key, the Chart automatically changes.

 

What happened to the Chart in Microsoft Word? Did it update, too?
Trust but verify. Switch to Microsoft Word and review your results. Yep, yep yep. The data is linked.

 

That’s it for this chapter. You done good. You can have two cookies.