Can't see in-cell dropdown using data validation

I have a number of sheets in a workbook and am using some form of data validation in each of the worksheets. Some of the worksheets are not showing the in-cell dropdown even though I have this feature checked. Is there something that may be turned off in one of these worksheets that is not allowing me to see the in-cell dropdown? This is the first time I have seen this happen. Thanks for any comments.

Is your dropdown pointing to a blank range list? Does the dropdown arrow appear? What kind of validation do you have for the ones that don't appear? Are the sheets that they don't appear on protected?

The range is not blank. The validation is a list from a named range and the sheets are not protected. I can't see the arrow. I have attached a sample. In the sample there are two sheets in which the in-cell dropdowns are not working "CommentsWeekly" and "CommentsQuarterly". The other three sheets work fine. I've tried to clear the validation and enter again but that didn't work either. Any insight appreciated. Thanks

There appears to be a t least one named Range missing - MainCategory

Here's some information that you can test.

http://www.contextures.com/xldataval...rowsNotVisible

But probably, in the end, redo-ing might be best option.

Have you run any code that deletes shapes?

When I tried to save the file to my desktop I got a Compatability Checker Warning message of:
"One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation rules will not be saved" I get 4 of these with Locations of: CommentsDaily, CommentsMonthly, CommentsQuarterly, CommentsYearly.

It must be related to "Scope of a Name" as defined in http://office.microsoft.com/en-us/ex...010147120.aspx
Also look at "In-Cell-Dropdown" in http://www.bettersolutions.com/excel...I215312022.htm

Also, on your worksheets perform a "Circle Invalid Data" - I don't understand why circles show on some of your sheets and not others.

On your CommentsWeekly sheet using invalid circles I see you have a Data Validation where the
Source: =Indirect(Substitite($C2," ",""))
What the heck is that?? Perhaps this invalid List Formula on this page is keeping Data Validation from working on this page??

Also read: http://office.microsoft.com/en-us/ex...005203449.aspx

Another forum had similar problem with it still a mystery. http://www.ozgrid.com/forum/showthread.php?t=73623

I haven't found an answer yet but hope the above will give some direction.

Maybe one of the smart forum gurus will have an answer.

The compatibility checker in 2010 has a bug in it with Data Validation where it gets confused by DV settings on sheets that are not active when it runs. It has been reported.