Select the cells that have drop downs, then go to Data-Validation and press
the Clear all button in the dialog box

"Don" wrote:

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