restricted values error

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!
 
J

Jan Karel Pieterse

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
 
Top