Today I realized that I was unable to copy worksheet with huge amounts of data validation dropdown lists (with reference to another database sheets in my general workbook) to a new book.
When copied it appears that there is no data validation drop list at all.
Excel on my computer is updated recently.
But when I was trying to do the same on another computer which is not updated, I could do that without any problem.