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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.