While there is a way for you to open two Excel workbooks at the same time, you can also open separate files in separate windows. In this article, we will be discussing 4 ways in which you can do so.
If you're working on a large Word document or Excel sheet ... if you have two copies open, you can close either version, and the one you leave open becomes the primary file.
If this file is ... opening two windows of the same workbook, you need to Run Excel with administrator privileges first. However, if it doesn’t solve your problem, you need to open the workbook ...