when I was using Excel2007,I can open a new excel application with double click Excel.exe.However,when I upgrade to version 2016,it doesn't work.What ever I try, I can't open a new workbook in a new application except code.How could I open a new application just through mouse click or any settings ,but not code like vba?

CodePudding user response：

1. You press ALT key and HOLD IT
2. click on the workbook you want to open (or just the Excel icon)
3. Keep holding down Alt key few seconds until a dialog box opens
4. "Do you want to start a new instance of Excel?" click on yes.
5. Done

This is very handy even if you want two VBA windows at the same time.