Page 20 - Finanancial Management_2022
P. 20
Identify external links in
Excel without using VBA
ometimes deliberate and sometimes inadvertent,
IMAGE BY VIPUL UMRETIYA/ISTOCK Take a LINKS function stored as a S external sources are referenced, because we can’t find
links to external data sources often work their way
defined range name and Transpose it
into our Excel workbooks. To understand what they
are and why they exist, we need to first know which
via dynamic arrays.
what we are looking for if we don’t know what we are looking for.
By Liam Bastick, FCMA, CGMA
I feel a U2 song coming on. That’s right, I can’t live with or without
my links — of which there may be more than one. Many years ago,
to list all external links in an Excel workbook:
18 I FM MAGAZINE I February 2022 I wrote an article that explained how a macro could be employed