What I posted earlier was not correct. Here is the new and correct one...
The age old Excel (Lotus123) has a problem with the new OS (es). An Excel file is being edited and there is a need to open another excel file for reference - bang! Excel opens this file also in the same window as the first one. I searched about in net, where they have too many good ways to solve this including tampering the registry entries.
As as old timer, I would like a simple solution. The point of actual fix seems to be to make Excel ignore other DDE applications (this does have a ton of other draw backs one of which is listed below). This could be done through checking the Excel->options->Advanced-> Ignore other DDE applications check box in the already open excel file.
Now an attempt to open another excel file from the browser, either by directly double clicking it or by right click and using the 'open with' in the context menu, the new file will be opened in a new window. There are three points to note:
1) All the current running instance should have the 'Ignore other DDE applications' set. Otherwise the new open attempt will open the file in the same window where this option is not set along with whatever that is already open there.
2) The default behavior is for Excel to open with the 'Ignore other DDE applications' not set. This could only be changed through the registry and this is bound to cause a lot of problems if not done correctly
3) Hence after immediately opening the new file, the 'Ignore other DDE applications' for that instance too needs to be set. Otherwise another new file open attempt will open the next file in that last window along with whatever that is already opened there...
Another problem is that if the first file refers to the second one (such as aggregates of some range in the second file), then with two files open, and if the values in the second file are changed (and saved too), the first file's cell will not get automatically updated as Excel has no way of knowing that the value has changed in the other file (separate processes). This will not happen if they are opened under the same window (same process). There is a need to manually update the first file (like using 'update' in 'edit link').
If you are wondering what is great about it, ask those guys who have to work with many excel files that are linked and they need to see more than one file at the same time and add to it that they have multiple monitors! The pain of the files opening in the same window is really bad in those cases. I do not know why MS Excel cannot offer a simple dialog on opening a file asking whether to open it in a separate window (process), of course warning the user of the limitations and consequences.