Have a way to set default open behavior to Open Excel in a New Instance
Currently Excel opens each workbook in a new window, but it is not a new Instance of Excel. The only way I've found to truly open in a new instance is to right click on Excel in the Taskbar then and then while holding down the "Alt" key left click on "Excel 2016". That would be fine except if I open something from the web it goes into a random instance that I have open. It is difficult to tell which files are open in which instances since they all "look" like they are in different instances.
Some of my Excel Workbooks are either large where an auto save will not only lock up that workbook, but also all other workbooks that are open in the same instance. Also if one workbook crashes, it takes down everything in that instance.
Many of my workbooks have code in them that I run. If I run code in a workbook and then switch my focus to another Excel workbook that is in the same instance, the code tries to run in the workbook that has the focus even though the code is in another workbook.
In prior versions of Excel, I was able to change a registry setting in order to open in a new instance. I have not found a way to that with office 360.
Personally, the only time I really want multiple workbooks in the same instance is when I want to copy worksheets between workbooks.
The behaviour should be reverted to that prior to Excel 2016, where clicking on the Excel icon on the Taskbar opened up a new instance. Having to now also press Alt is not a positive change.
There WAS an option in Excel 2013, and it was very useful. Now - especially with the strange decision to share undo history among all workbooks open in the same instance - its an absolute nightmare. There's a poor workaround in another thread that really isn't acceptable if you need to open something from Excel or Explorer. We really do need this option back.
[Deleted User] commented
Would it be possible to add an option to choose how Excel opens files ?
1/ Open an Excel file in a new Excel instance
2/ Open an Excel file in an existing Excel instance