Hey guys,
This might be a simple question, but what is the reason that banks and companies unlink the formulas in excel and just paste values before sending across excel sheets to clients etc.?
Thanks,
| +221 | Why UBS Is the Worst Place to Start Your IB Career | 35 | 2h |
| +162 | ONLY THESE BANKS OR YOU STRUCK OUT | 41 | 2h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 1d |
| +58 | Indiana University Fraternity Pipelines | 36 | 1h |
| +50 | Rogo AI | 20 | 15h |
| +44 | Suspended for a Year | 19 | 10h |
| +43 | Elite Boutique interview questions | 11 | 49m |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 2d |
| +39 | UBS 2nd Year Analyst Q&A (2026) | 16 | 42m |
| +23 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 16 | 14h |
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.
If I had to guess, it could be because the client might break the model if they don't understand it. Or also because banks believe that the Excel formulas are their proprietary information. I'm probably wrong though.
You are correct - my firm thinks that the excel models we build are proprietary information. Also, it's MUCH easier to do this from our perspective since we don't have to answer questions about them blowing up the model.
I was actually pretty surprised by this when I got here. I still think most banks send full models to clients.
Pretty much this. If you've ever been sent any model (or have looked at some old models), you'll notice links might refer to " 'C:\User\Folder[Filename.xlsx]TabName'!A1' " If you send a model with that link, it'll REF out (since that file doesn't exist on their computer).
Either because model links to original source files in separate files that tends to #REF out when you send to different people via email so they just paste values everything, and/or it's harder to find a bust in the model when it's all values.
Occaecati consectetur cupiditate voluptatibus odit suscipit molestias. Quia eos cum ea aut aspernatur velit. Aliquid veritatis vel dolores suscipit quis error id.
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...