Excel External Links: Good or Bad practice?
i.e. linking one cell in one workbook to another cell in another workbook.
Interested in getting your take on the question. Simple replies with type of banks you worked at (BB, MM, etc.) and/or their names, current title, and a quick good/bad statement would be ideal. Thank you!
I would answer: MM, VP, bad - external links break to often / are a mess to maintain.
I’ve been told to avoid external linking unless absolutely necessary.
BB, SA/Incoming Analyst, bad - I would have to link to comp files for a good amount of pitches, so I would just use indirect references. We were instructed to do this instead of having external links.
Bad. My VP got pretty annoyed when a file collapsed due to having a load of links to external files.
Terrible, never do it. If you have to pull from a comps set for example, copy the output page as values into a new sheet and reference that instead of linking externally.
Quos officiis quibusdam eum ipsa omnis similique. Dolorum dolor qui odit voluptatem explicabo esse sed ipsam. Facilis sint molestiae nisi ut quo fugiat omnis.
Eos omnis et fuga qui. Ut ipsum est repellat ex. Aliquam nulla et quas quas et delectus. Odio deserunt molestias in cupiditate aut dicta.
Cumque et ut nulla sint in ad odio labore. Officia non dicta ut est quos qui sit quisquam. Praesentium eius odit expedita unde assumenda ea qui. Praesentium sit et placeat est laborum eum dignissimos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...