I have put up a data validation on my spreadsheet. It works fine until today when the droplist list icon is gone. I tried to redo the box list but it does not allow me to select the range. I clicked data validation >>>>>Allow "List">>>> Source. It does not allow me to select the source in other tab. What could be the problem? Please reply. Thank you.