Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated ...

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 ...