Microsoft releases a major update to the Excel for Windows interface, including a totally modernised "Get Data" dialogue that ...
Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated range or open the file in another program to completely bypass the rules I ...