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!
If the workbook is protected, this option won't be available.
To turn off protection, choose Tools>Protection >Unprotect Shared Workbook
> 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
[quoted text clipped - 5 lines]
>
> Thanks!

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html