Data Validation in Shared Workbook

S

susieqhersh

I set up a shared workbook that included some data validation. Now I
need to add an additional valid value but when I go to Tools, Share
Workbook, Editing I cannot turn off "Allow changes....) so that I can
change the validation. It is OK if I lose the change history up to
this point.

Any ideas why this option is disabled?

Thanks!
 
D

Debra Dalgleish

If the workbook is protected, this option won't be available.

To turn off protection, choose Tools>Protection >Unprotect Shared Workbook
 
Top