Excel Data Validation is Grayed Out


  • I have a spreadsheet that has the Data Validation option grayed out.  I can open up a totally new spreadsheet and the Data Validation option is not gray but regular blue that I can click and then add a look-up list table.  When I go back to the other spreadsheet, however, the Data Validation tab is still grayed out.  Does anyone know why this is and how I can fix it?  I've looked through the Options choices trying to find a check box or whatever that will enable the Data Validation choice, but nothing I've seen works.
    Thursday, May 31, 2012 9:19 PM


All replies