At times you may want to use information that exists in a different Excel file. This
use of external information is referred to as "linking" in Excel. This lesson
will show you the basics of creating workbook links in Excel.
Creating Two Files
This example will require that you create two files link1.xls and link2.xls. Let's
start with creating link1.xls.
This is a very simple file and only contains the text "this workbook" in cell A1. Save this file as link1.xls.
let's make link2.xls.
This worksheet only has one data entry in C1 with the value "has a link". Save this file as link2.xls in the same directory as link1.xls.
Excel Linking: The Reference
As you can probably tell, we are going to link to the information in our second file so that
our first file has the line "this workbook has a link". The actual link reference is quite complicated looking, so
please take your time to understand each component of the Excel Link.
There are three major parts that a link must have to be valid:
- Workbook: This is the filename of your Excel document.
- Worksheet: This is the worksheet name of your Excel sheet. The default name would be Sheet1.
- Cells: The cell(s) which are going to be linked to.
These three parts combine to make a pretty ugly looking blob of text. Using the general
terms from above, this is how a generic link would look.
For our example, the Workbook is link2.xls, the Worksheet is Sheet1 and the cell is C1. Our
link would then be:
- Enter this link into cell C1 of link1.xls and hit Return.
- Your link1.xls file should now properly link to your second file to display "this workbook has a link".
Found Something Wrong in this Lesson?
Report a Bug or Comment on This Lesson - Your input is what keeps Tizag improving with time!