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
   15   16   17   18   19   20   21   22   23   24   25