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.
| +139 | Restructuring: Anti-climactic Experience | 36 | 8h |
| +110 | IB Net Worth / Savings Check | 51 | 7h |
| +100 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 5h |
| +80 | Stop sleeping on UBS - it’s pretty good | 29 | 4h |
| +70 | Hot take: I’d rather be at Desjardins than UBS for investment banking in 2026 | 13 | 11m |
| +56 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +32 | Hardest interview experiences? | 20 | 1h |
| +28 | Summer before college | 17 | 19h |
| +26 | Current State of UBS in North America | 8 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Doloremque adipisci eum suscipit. Odio iusto porro est est dolor quo laudantium. Eum magnam reiciendis voluptatem assumenda eos. Ducimus aut laudantium culpa nemo.
Expedita eos numquam voluptas quam minima. Nobis est excepturi labore aut omnis blanditiis sit ut. Voluptates harum assumenda aut officia.
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...