I use MS Excel 2003 and today ALL cells that had previously functioned as drop-down menus with the data validation function referring to a listed range suddenly stopped working. They still validate, they will only let you enter the appropriate values, that is IF you know what those are, but whereas before you would click the cell and the pull down arrow would appear and you could click that for the list, now nothing happens.
You can even go to the data validation info for each cell and the settings are all there, the drop-down box is checked, and the correct range is still in place. Also you can make a new data validated cell with a drop down list and it works perfectly, but there are hundreds of others that are now seemingly broken.
It seems incredibly strange to me, and I opened a version that I had saved just a bit earlier (but before adding a whole lot of important data since then) and the pull-downs are working fine.
Has anyone heard of such a thing or why it might happen or better yet, how it might be fixed?
I am very careful to save my files and handle them with care. I have been working on this one for years. It is just so weird for something so normal to simply cease to function. I closed and reopened the program, rebooted the computer, tried the file on a different machine, just hoping it was a glitch or something, but all was to no avail.
I would really appreciate any insight anyone can give me. Thank you so much in advance if you can offer any clues at all.
Bookmarks