To make sure I minimize intervention and I don't lose any existing information, I only pasted the data validation cells where I would add new entries - so the old entries are not linked to my lists anymore.
:max_bytes(150000):strip_icc()/001-how-to-insert-checkmark-in-excel-4691759-60af4c600daa4ab1980ee29296395b5e.jpg "insert a drop down menu in excel 2016")
It is fortunate that I had not changed the architecture of the file at all, so the sheet names + cell numbers were accurate. I couldn't solve it following the above advice, so I actually manually copy-pasted the cells with data validation from a quite older back-up version of the file that I had stored in the old PC (which was never copied to the "new" PC).
Interestingly, this was the case for all recent back-up files I had created in the new PC, when I tried to open them again in the old PC. I created the file and used it for months (maybe 2-3 times a month) on a certain PC, then copied it & used it on another PC for about 10 days more intensely, then back to original PC and the data validation was instantly gone. I had a similar problem, only my cells had lost altogether the data validation (and the "For objects, show" option was set to "All").
0 kommentar(er)
