To Edit or Update an Object
1. Double-click an OLE object to open it in its parent application.
2. Edit the content in the parent application and save the changes. The changes appear in your worksheet.
3. To update the contents of a linked object when it is not activated, on the Input/Output tab, in the Objects group, click the Update Link icon .
Was this helpful?