Forum Discussion
Data Validation: Error alert not displaying when invalid data is entered.
I created a workbook for training purposes; in one worksheet containing an Order Records in an Excel Table. The column labeled Inv_No has data validation applied limiting the invoice numbers from the...
I changed the definition of AvailInNo to
='Inv Numbers'!$F$5#
Data Validation then started working as intended. I can't explain it, but give it a try.