Phanatique
New Member
- Joined
- Feb 13, 2017
- Messages
- 1
Hello,
I have a problem with Excel (2016 - Office 365). In a worksheet, I use validation. Quite simple validation:
On some occasion (a magic action, I'm not sure what action it is, I think when I have moved a column) the validation of several (but not all) colomns is corrupted. In that case, ONE cel has several validation rules, as a stack. When I delete the validation of the cell, only the top rule of the stack is removed. Sometimes I have to remove about ten 'layers' of rules. The stack consists of rules used on other cells of the worksheet.
Ater I removed all wrong validation rules (as far as I know they are wrong) and after another magic action, the validation is corrupted again, I can start cleaning again.
Does anyone know what this is and what I can do against it?
Kind regards.
I have a problem with Excel (2016 - Office 365). In a worksheet, I use validation. Quite simple validation:
- valid date
- input list (refering with a name to a range with the list items).
On some occasion (a magic action, I'm not sure what action it is, I think when I have moved a column) the validation of several (but not all) colomns is corrupted. In that case, ONE cel has several validation rules, as a stack. When I delete the validation of the cell, only the top rule of the stack is removed. Sometimes I have to remove about ten 'layers' of rules. The stack consists of rules used on other cells of the worksheet.
Ater I removed all wrong validation rules (as far as I know they are wrong) and after another magic action, the validation is corrupted again, I can start cleaning again.
Does anyone know what this is and what I can do against it?
Kind regards.
