In Excel, external references reference a cell or a range of cells in another workbook. The formula of an external reference result can be displayed in a formula bar. A formula bar displays the value or formula entered in an active cell. It displays information being entered as you type in the active or current cell. Contents of an external reference can also be edited in the formula bar.
