How do I remove a value limit "User has restricted values that can be entered"

[born2dive00]

Hey guys, So I figured out how to extend the range of the table. Surprisingly a simple row insert worked fine.

But now I have run into a new problem, In the Order ID, Qty, and Price fields on the Input sheet when I put a value greater than 99,999 or if it uses anything other than numbers say hyphens like with a CAS number, I am getting a message "The value you entered is not valid", "A user has restricted the values that can be entered into this cell"

Now this book is not protected and no password is needed as it is a free license. Is this error a VBA issue, or is it something else in the macros??? I dont want any restrictions on the cells I need to be able to enter numerical, numerical with hyphens alphanumeric, and words or letters

One other thing I noticed is the QTY seems to reset each time I use the drop down box under Select Order ID, is there a way that I can get it to match Q9 when cycling I use the select Order ID or the view records, while at the same time allowing it to be edited, basically do the same as D5, if I select order ID or view records, it changes, BUT it will also allow me to enter the data manually, then update it.

Please let me know how to fix this and thanks

[Roel Jongman]

There is a data validation on those cells you need to remove.
You can find this in the DATA menu then find the data validation icon it should be in the section after the filter and sort close tot the "text to columns" option.