 | List of all workbooks linked to active workbook
|
 | Links attached to controls such as buttons |
 | Links in Named ranges and hidden named Ranges |
 | Indicator showing which linked workbooks are currently
open |
 | Display of full path name of linked workbook
|
 | Standard Edit/Link function available including:
 | Update of links |
 | Open source file |
 | Change source file |
|
 | Additional functions:
 | Go to source file |
 | Close source file |
|
 | Display of all link references to selected linked workbook showing:
 | Sheet or object in which link is found |
|
 | For cell links, the display shows:
 | The sheet, the cell reference, and the formula |
|
 | For Named Range links, the display shows:
 | The Name and what the Name refers to |
|
 | For Control links, the display shows:
 | The name of the control, and the assigned macro which refers to the linked workbook. |
|
 | Quickly jump to the selected link reference
|
 | Add a report to the active workbook (as an additional
sheet) listing all links in the workbook |
 | Easily change the linked workbook to another source
|