Drop Down Tab not showing-Tried Everything
 

I am working on a massive spreadsheet that would take weeks to redo.
All of a sudden I can see the validation lists on 3 out of 120 sheets. Was
working ok this morning. I have the "Show drop down" checked and my
Tools/Options are set to Show on. I am working in version 2000. My file must
be corropted. How can I fix??
Thanks,
Barb