Worksheet Links

Hello Denise

Thank you for your question.

At the simplest level, a link can be created by making one cell equal to another.

For example, if you have two files, Book 1 and Book 2, you can link a cell in Book 1 to a cell in Book 2 by selecting the cell in Book 1, typing in = and then selecting the cell you wish to link to in Book 2; and pressing Enter.

Generally you would create a link when you need data in one file or sheet to be kept up-to-date with data in another file or sheet; perhaps if that data is then used as part of further calculations.

It is difficult to relate this to a specific example or context as this would be dependant on what you are using Excel for on a day-to-day basis.

I hope the general principle of linking makes sense though.

Kind regards
Amanda