Restrictions Issues

Solved
Hello,

I'm working on an Excel workbook that has already been through several hands. I need to modify it.

To test a new formula, I inserted a new column where I put my formula. And then I get the error message:

"The value you entered is not valid

A user has restricted the values that can be entered in this cell"

My formula works perfectly in other cells, so the problem doesn't come from there.

How can I lift this restriction?

Thank you in advance,

Best regards,

Configuration: Windows 7 / Firefox 39.0

1 answer

  • Votes
  • Date
  • Descending date
  1. Good evening

    Data tab - Data validation
    Allow All again

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1. a big thank you
    2. Thank you for your help.
    3. So awesome, thank youuuu!!!! ^^