Linking between cells in the same worksheet --- You already know how to do this. If you want cell A1 to show the value of G3, in A1 you enter the formula =G3.
A1 is called the destination cell.
G3 is called the source cell.
What is new this year is linking a cell in one workbook (that is, an Excel file) with a cell in another workbook (another Excel file).
Excel sessions -- Do remember what we looked at in class - linking a cell in one worksheet with a cell in a different worksheet only works when the files are open in the same "session" or "instance" of Excel, that is, when Excel is started only once and all the file are opened within that one session of Excel, not when Excel is started multiple times from the Start button and the workbooks are opened in different sessions of Excel.
Once you know how to link between workbooks, it is even easier to link between worksheets in the same workbook.
You will see that the process itself is simple and straightforward. The reason we spend a couple of classes on it is because it's just as important to learn where linking might be used, why you would link cells, how it adds to your power and efficiency with Excel. The three worksheets you create for three salespersons plus a summary worksheet is an example to start you thinking about how cell linking can be used.
- Online Resources
- Microsoft
- London School of Economics
- Data.no
- InformIT
