Option of opening new file in current instance or new instance (dual monitor support)
When a file is opened it automatically opens in the same instance which does not allow you to have two workbooks side by side on two monitors (without manually dragging the excel window across two monitors every time).
I know you can manually open a new instance of excel but when opening a file it seems to randomly choose which instance it opens in, sometimes both files are in the same instance which is useless for what is needed.
Manually finding the file through the open command it not useful either due to large numbers of files being from outlook (unsaved).
James Boyett commented
It's very frustrating to not have the icon right-click option to open a new instance anymore. Now if Excel is busy doing something (VBA, data refresh, etc.), I have to wait until it is done before I can attempt to open a new workbook.So much for multi-tasking. What is worse is that the new workbooks still open after the first completes it's task.
This is especially frustrating when a hyperlink in 1 file is used to open a 2nd file, because there is no workaround involving opening a 2nd instance of Excel before opening the 2nd file that way... also frustrating that MS Word has always had this option, but Excel doesn't. MS Office products should have more consistency from one sister-product to the next.
Bharath Vullanki commented
Infact PowerPoint has this capability. Why not with Excel which will make working with multiples files really easy with Dual Monitor Support.