In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed out. I can change the drop down choices, though. That is if I change the list, the list that drops down changes. If I open a new workbook Validation is no longer grayed out. Any ideas on how to "un-gray" the validation so I can add or remove drop downs?
31 Answer
Data validation (and a few other things) cannot be changed in shared workbooks. Unshare the file, change the data validation settings and share it again.
Be aware that with shared workbooks the only question is when (not if) they will become corrupt and stop working as expected. Shared workbooks are notoriously unreliable, impossible to troubleshoot and should be avoided. Excel was not designed for simultaneous multi-user access. If that functionality is required, then a system like Access or SQL should be used.
