9/9/2023 0 Comments Drop down list in excel![]() ![]() ![]() ![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |