Anyone have a suggestion on how to link an Excel spreadsheet to Word or PowerPoint? I always copy my exhibit / graphic from Excel as a picture and then pasted as an enhanced metafile into my destination sheet.
Needless to say I've become extremely frustrated with constantly having to go back and re-paste exhibits in reports in Word / pitchbook in PowerPoint.
Any words of advice from the WSO community?
| +117 | Investment Banking US League Table YTD 2024 (FactSet) | 81 | 5m | |
| +82 | Intern Ettiquette | 17 | 1d | |
| +81 | Would comitting to ATL İB be stupid? Please give feedback. | 45 | 9h | |
| +72 | Big Layoff at Barclays - 5/1/24 | 44 | 14m | |
| +58 | A shitter's comprehensive guide to sophomore year recruiting | 6 | 19h | |
| +58 | Sleeping on Jefferies??? | 27 | 2h | |
| +57 | “Americans just work harder” | 35 | 14m | |
| +56 | NEED NY RESTAURANT RECOMMENDATIONS | 38 | 10h | |
| +55 | What's up with RBC nowadays? | 18 | 19h | |
| +40 | 5-Step (Borderline Psycho) Pre-Superday Routine I Used to Land Every IB Internship Offer | 2 | 7h |
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 use the capIQ plugin, it allows you to update all of your linked items with one click. Although, I usually go through and do them individually just to make sure nothing gets messed up.
Home run, my firm uses the CIQ platform. How do you link between your destination sheet and excel workbook?
Not sure I know what you mean but there is a CIQ add-in tab in excel where you hit copy and then you go to the ppt add-in tab and hit paste. Obviously you can use alt shortcuts and make it pretty quick.
Paste special, click "Paste Link" option on left hand side, choose "Microsoft Excel Chart/Worksheet Object". Right click on object and select "Update Link" when needed. Should update automatically if both files are open I believe.
Pasting pictures is the way to go for me. Linking objects and editing the original within a ppt will get really confusing when you mess something up.
Wow Buegie just straight hooking it up. I can't believe it, my firm set up CIQ for Excel only. Downloaded the PowerPoint and Word Plugins, and boom - game over. Just a straight powerplay now. You just saved an absurd amount of inevitable wasted time from my life with that advice.
Silver Banana to you my friend.
In doloribus dolore vel omnis adipisci. Facilis aut consequatur laborum vitae. Et quisquam consequuntur dolor deleniti voluptate. Nobis earum tenetur quo similique asperiores. Porro mollitia est pariatur illum itaque. Tempore dolore accusamus et molestiae cum sit qui sed. Odit sunt est quo quae repellat voluptatibus fugiat.
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...