When you create formulas in Excel and refer to a data point in an another workbook, Excel creates a link to that workbook. So your formula may look like something as shown below: Note that the part highlighted in yellow is the external link (also called e