This is a straightforward Excel question, although the answer may not be straightforward.
I have a spreadsheet
with a number of columns regulated by Data Validation.
They are linked to lists with DV, which normally generates
a nice drop-down box when you click on the cells.
I inserted a column into the spreadsheet, and now DV doesn't
generate a drop-box anymore! In any of the columns! The "In-cell dropdown" box is still checked in my Data Validation
screen, and the cells are still bound by validation to only conform to the lists.
Can anyone think of why these
boxes would have disappeared? I've shut down Excel and re-opened the file in case it was a momentary glitch. I've deleted
the inserted column... In short, I've tried everything I can think of.
Even if I remove Data Validation from the columns, and re-instate it with the "In-cell dropdown" box checked, I still don't
get my drop-boxes.
I would be totally happy to send my complete file to anyone who wants it (although it's a bit
big, as I have to send the directory structure if you don't want to get an error, about 1 MB), but anyhow - I'm reasonably
desparate to get the drop-boxes back in.
Any thoughts would be appreciated.