Data Validation no longer working.

For some reason, the data validation has stopped working which is affecting how my workbook functions.

Any help?

On the worksheet TR 1, cell B1 should be a drop down list that uses the "teams" list. This then impacts on the drop down list in C3:C18....

Help please.

Cheers,
G

Do the following:

File=>Options==>advanced==>Scroll down to "Display objects for this workbook" .For Objects, show click "All" Radio button


This is turned off in your workbook so drop down arrows do not show.


(Answer found by "Googling"!!!)

I do not seem to have "Display objects for this workbook."

I haven't Excel 2007 but i'll post back the updated workbook.

There must be this option somewhere!