Data Validation Menu Greyed Out?

T

TomP

I have a spreadsheet that already has "drop down" arrows on every cell in a
column data to select from. I was able to find the data that is supposed to
be used for the "drop down" menu and that the data name range assigned to it.


The problem I'm having is that when I go to the menu bar and select Data,
the Validation option is greyed out.

How can access the data validation menu when it is greyed out? The entire
file is unprotected.

Thank you for your help!

Tom
 
G

Gord Dibben

The sheet is protected?

The workbook is shared?

You have more than one sheet selected?


Gord Dibben MS Excel MVP
 
T

TomP

From looking at the Protection menus, the only option I have from the Tools
menu is to "Protect Shared Workbook". All other options are greyed out.

Thank you for your help!

Tom
 
T

TomP

Just to let you know, the workbook was passed to me to use. I know there
has to be something simple to access the data validation menu from the menu
bar. The data list is stored in a separate worksheet and need to be
modified.

Thank you!
 
G

Gord Dibben

That indicates the workbook is shared.

Go to Tools>Share Workbook and unshare it.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top