Using Excel on both monitors and you're in two separate files, but you want each file to recognize each other.
Example:
You have a number on one file in left monitor and another number in another file on your right number. How do you multiply (or do anything really) the number in file X (left monitor) by number in File Y (right monitor)? Is this not possible?
| +341 | Evercore Intern Seizure | 53 | 8m |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 27 | 1h |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 3h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 1h |
| +30 | How do I understand vs. just memorizing? | 5 | 1h |
| +27 | Which groups are ideal for laterals? | 12 | 3h |
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.
To get another excel open on my 2nd monitor, I have to open Excel again and then open whatever file Im looking for, so Im assuming thats why the two files dont acknowledge each other since they are two different instances of excel.. but im wondering if there is a way
wait really? ... just link the cells.
type in your formula and reference the other worksheet... (alt+tab to jump to the other worksheet)? maybe i'm not getting your question...
edit: ohhhh. nvm i see what you're saying. sorry, can't help. excel 2013 lets you open multiple instances now though, if your bank's upgraded.
You can still do it the same way you would do it if it were to be on the same instance of excel instead of two instances except when you update the numbers it doesn't auto recalculate. You have to save the file that you changed the number on, and then recalculate numbers on the other one. Annoying. yes. But possible.
Also, when I copied just the file name over like it would be done when done in the same instance of Excel, it automatically put in the whole path of the file instead. ex. Instead of "[filename.xlsx]Sheet 1"$A$1 it's C://Desktop/filename.xlsx....
A non pretty fix is to resize the excel window across both monitors and manually resize each book to fill one monitor.
That would actually be the simplest way and would look pretty much the same. other than the tool bar at the top.
This
Illo quia fugiat recusandae odit dolores quos quia. Vero fugiat quae magnam corporis qui ut at. Sunt officia tempora dolorem dolorem laborum ipsam. Rerum sunt in nostrum dolorum sunt ducimus id. Quia dolor nihil voluptatem. Optio minus sit ipsam est.
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...