restricted values error

  • Thread starter Thread starter xavi garriga
  • Start date Start date
X

xavi garriga

Dear all;
I'm trying to delete part of a formula in one cell, but an error appears:

"The value you entered is not valid.
A user restricted values that can be entered into the cell"

What can I do?

Thanks!
 
Hi Xavi,
I'm trying to delete part of a formula in one cell, but an error appears:

"The value you entered is not valid.
A user restricted values that can be entered into the cell"
Click to expand...

This is caused by Data, Validation on that cell. Change the rule and you sould
be OK.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top