1.3k views
2 votes
If a formula is copied and then pasted as a link to another location, what will be true of the new linked data?

2 Answers

1 vote

So far, all the discussion of moving and copying has referred to content that exists in one or more locations, with no connection between the locations. Copying a section of a worksheet or an entire worksheet to another workbook saves you time and effort, but after the section or sheet is copied, the relationship between the source material and the target location might end (unless formulas are included that create links, as described shortly). If you go back to the source worksheet and change any of the data, the changes are not reflected in the place(s) to which the material was copied.

User Jaber Kibria
by
6.5k points
4 votes

Answer:

It will be updated if the original cell is updated.

Step-by-step explanation:

User Freaktor
by
6.4k points