You might want to open two files in two separate windows to compare them. Also, if you want to edit two files simultaneously, you need to open them separately. That is why you can change Notepad ...

Microsoft Excel has several features designed to help you recover unsaved versions of spreadsheets and prevent data loss. If Excel closes before you save a file, you should see a Document Recovery tab ...