restricted values error

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

 

[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"

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

 

[xavi garriga]

Thanks, i've tried it and it works perfect!