I have copied and pasted data from one workbook to another. The original one
had dropdown menus and the dropdown has come with the data that I wanted.
(The new dropdown has no options). Normally I wouldn't care but I need to
protect the sheet and I cannot protect the cells where there is a dropdown
for some reason.

Could anyone offer any solutions please

Thanks