Restrictions Issues

Solved
SuperAmbi Posted messages 14 Status Membre -  
 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 réponse

via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Good evening

Data tab - Data validation
Allow All again

Best regards
Via

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

So awesome, thank youuuu!!!! ^^

0