1
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?
I don't have 2003 any more, so can't test this, but is it happening on all cells/ranges, or can you click on some individual cells and add it? Are there merged cells involved? Because those can mess up some functions. – techturtle – 2013-03-28T18:44:05.133
Is the worksheet protected or set as shared? – Col – 2013-03-28T18:48:38.227
You said "The sheet is not locked or protected, but it is shared." Did you try turning off sharing? – CharlieRB – 2013-03-28T19:38:11.317