I am working on a spreadsheet that has multiple tables in one page. I have manually validated each table using the formulas similar to this
The spreadsheet was tested multiple times by myself and different users. When this was sent to business users, they could not input any number at all and get the error message that there was a data validation in place.
I went back to the original spreadsheet that was sent to them and I am now getting the same error message also.
I am very confused about this because I have tested this and manually validated each table.
EDIT: bearing in mind, this formula and data validation works across other worksheets. The cells in this worksheet definitely do not have protected cells.