Q. What would you do when you want to update the data in an embedded worksheet range? (Solved)
1. double click the worksheet range object
2. right click worksheet range object & choose format object
3. edit the data in the destination document
4. edit the data in the source document.
- a. double click the worksheet range object