Open two Excels, Same Name, Same Time
Normally Excel can't Opening Two excel workbook with same name at the same time, Microsoft has given us a solution to do so.. Step 01 Just open the first excel workbook. Step 02 Open the second excel workbook. Just after opening the file hold on the Alt key. To this you have to be quick. What I use to do is, select the file and press the enter key on the keyboard and quickly press and hold the "Alt" key and suddenly for a little time. Then it will prompt a window asking yes or no to open the file in a new instant. Click on yes to open in a new window. This doesn't always have to be for same name files. Even if the name is defer you can open a file from a deferent naming condition. Let's say if you have open a power query editor then excel doesn't allow open another excel workbook file. in such a case this option is a life saver. please refer this video for more information