Restrictions Issues

Solved
SuperAmbi Posted messages 14 Status Member -  
 Pat -
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

  1. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Good evening

    Data tab - Data validation
    Allow All again

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    51
    1. pitch
       
      a big thank you
      0
    2. josh
       
      Thank you.
      0
    3. Sofiane
       
      Thank you for your help.
      0
    4. Pat
       

      So awesome, thank youuuu!!!! ^^

      0