excel list external references code example

Example: excel list external references

Excel Find external links used in formulas:
> Press Ctrl+F to launch the Find and Replace dialog.
> Click Options.
> In the Find what box, enter .xl*
> In the Within box, click Workbook.
> In the Look in box, click Formulas.
> Click Find All.