Question

If you make changes after establishing links between workbooks the data also gets changed.Why?State the steps

Answer 1

"With the simple edit, paste command places copied content in a new location. Choosing the edit paste particular enables you to create a link between the source and target worksheet or workbooks.The following steps are hence used.

Both workbooks should be open and saved, select and copy the content in the source worksheet that will be linked to the object.

Move to the target worksheet and select the cell where you want the link data to begin and will edit paste special to open the different paste dialogue, make any selections concerning the content then click the paste link button.

"