When Excel data validation is set to "Error" then a popup comes up that says this is an invalid value and the user is prevented from entering any data. However, this is a BIG block from entering data in the field. The bigger solution is building a VBA script to add new values to lookup lists. Meanwhile, this issue here proposes ANOTHER solution which is to just change ALL Excel validation to "Warning" since the VBA solution may take further discussion and thinking (more on this later).
Essentially, this issue proposes a popup comes up in Excel and will provide a WARNING hat this value needs to be added during web validation but STILL lets users enter the desired (non-valid) data anyway.
jdeck88
commented
9 years ago
When Excel data validation is set to "Error" then a popup comes up that says this is an invalid value and the user is prevented from entering any data. However, this is a BIG block from entering data in the field. The bigger solution is building a VBA script to add new values to lookup lists. Meanwhile, this issue here proposes ANOTHER solution which is to just change ALL Excel validation to "Warning" since the VBA solution may take further discussion and thinking (more on this later).
Essentially, this issue proposes a popup comes up in Excel and will provide a WARNING hat this value needs to be added during web validation but STILL lets users enter the desired (non-valid) data anyway.